9e9+
January 29th, 2005, 04:35 PM
how to change the below query to so that?:
if num < 6000,
Format num as x,xxx.xx. such as 6 - 456 - 5.78 - 4.6 - 6.8 - 4,678 - 5,567.45
else
Fomrat num as sientific number.
How??.
SELECT fname, num
case when option = 0 then num else null end as num
from data
group by fname, num
if num < 6000,
Format num as x,xxx.xx. such as 6 - 456 - 5.78 - 4.6 - 6.8 - 4,678 - 5,567.45
else
Fomrat num as sientific number.
How??.
SELECT fname, num
case when option = 0 then num else null end as num
from data
group by fname, num