General information
Forum:
Microsoft SQL Server
Title:
How to do an easy sql statement
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only