Ok, for example

SELECT IsNull(Firstname,'No First Name') FROM Employee

or any other query involving funtions like IsNull.

Joost

"Ram�n Jim�nez" <[EMAIL PROTECTED]> schreef in bericht
news:[EMAIL PROTECTED]
> Joost,
>
> Could you post an example query? These functions require a special
> syntax, e.g. SELECT { fn COALESCE ( MyField, 'Empty' ) } FROM MyTable or
> something like that.
>
> HTH,
>
> Ram�n
> -- 
> ZCacheLib - Open Source Extensions for Cach�
> http://www.zcachelib.org



Reply via email to