Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Louis C Lam — — source: Informix-list mailing list archive (1991-1998)
Hi all.
Is there a way to tell a SQL command to return a money value
without the $ sign? For example,
SELECT unit_price FROM products will return:
unit_price
$300.00
$250.00
but what I need is:
unit_price
300.00
250.00
I know I can manually remove the $ sign after the value is
returned, but is there a way to force it to return a value
without the $ sign?
Thanks!
Louis
Your privacy choices
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.