If the result of SELECT is nothing print "Not Found" 1

[kia70]

A newbie question:
Sometimes the result of SELECT might be empty/null. Instead of printing nothing I want to:
If Empty/Null Print "NOT FOUND"

Any clue... Thanx

 

[PHV]

Something like this ?

SELECT IIf(Trim(yourField & '')='','NOT FOUND',yourField) As myResult

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886