>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