On Sun, 2 Feb 2003 13:20:38 +0100, alex wrote:
>i ask myself how to prog my select statments platform independend if i need
>ISNULL function on varchar fields in MsSQL2K... this will not work on a move
>to MySQL and so on...
I don't know for sure about MS-SQL, but this works in MySQL:
SELECT * FROM table WHERE field IS NULL
or
SELECT * FROM table WHERE field IS NOT NULL
Here, the SQL keywords are in uppercase, table/field names in lower
case.
I think I have used this syntax in MS-SQL too.
--
Bart.
