Re: platform independence and ISNULL/nolock with MsSQL?

[alex]

> SELECT * FROM table WHERE field IS NULL

thats not the problem... :-). one example - i hope this makes it clearer
what i mean...

SELECT ISNULL(ID,'') AS ID FROM $dbtableWith(nolock) WHERE
SUBSTRING(ID,7,6)=LEFT(?,6)


Alex