Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to do an easy sql statement
Message
From
04/03/2002 16:26:40
 
 
To
All
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Title:
How to do an easy sql statement
Miscellaneous
Thread ID:
00628074
Message ID:
00628074
Views:
56
What's the easiest way in a select statement to return 'Horrizontal' if a field value is 0 and 'Vertical' if a field value is 1?

ie; select field1,field2,iif(field3=0,'Horrizontal','Vertical') as feild3

Thanks,
Darren.
Next
Reply
Map
View

Click here to load this message in the networking platform