>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.
You can use CASE function.
select field1, field2,
CASE WHEN field3=0 THEN 'Horrizontal' ELSE 'Vertical' END as feild3
--sb--