Help on sql Statement 1

[PeterWallace]

I have a table something like

Tno as Long
Rego as String
State as string
Front as Boolean

What I would like to know is how can I write SQL so that can
Select Rego , State ...

AND

if Front is True Then want answer as a String "FRONT
If Front is False I want answer as a String "REAR"

Thanks in anticipation
Peter

 

[SkipVought]

Hi,

IIF(Front,'Front','Rear')

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]

 

[PeterWallace]

SkipVought

Thank You


I found another solution for the Times when I use for input to a DataReport about 40% of the Time I need

Make the DataFormat Boolean
and Use The OPtions for True and False to Display Answer
Peter