Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Conditional column in SQL Syntax
Message
From
15/03/2006 00:54:24
Czarina Joyce Villanueva
Innovision Systems International
Manila, Philippines
 
 
To
All
General information
Forum:
Microsoft SQL Server
Category:
Other
Title:
Conditional column in SQL Syntax
Miscellaneous
Thread ID:
01104425
Message ID:
01104425
Views:
51
If VFP, I can have below statement:
Select IIf(group = 1,'A','B') As sorter, amount From table1
Is this possible in SQL Server T-SQL? Actually, I tried it but it gives me an error. Or I am just missing something?

TIA
Next
Reply
Map
View

Click here to load this message in the networking platform