if then in a query expression

[patfee]

hi,
is it possible to use a if then sort of statement within a query expression?

i.e. if checkbox = true then SE_required

Thanks
PAtrick

 

[lespaul]

yes:

SELECT F1, F2, iif(somecondition, 'Something', 'Nothing')...

where the arguments are:

iif(logical comparison, value if true, value if false)



Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

 

[patfee]

offcourse.... i keep forgetting about this piece of code...
thanks!!
PAt