Home Forums SQL Server 7,2000 Strategies Select clause SQL Quary RE: Select clause SQL Quary
Dave Ballantyne
SSC-Dedicated
Points: 33566
More actions
July 3, 2009 at 3:03 am
#1019670
By using the case statement
select ....,case when money >=10000 then 'A' else 'B' end as Grade
from ....