The IS [NOT[\] NULL is ANSI SQL operator. You cannot compare with NULL because result will be NULL, not True or False.
'dbo' is owner (or Schema in 2005) not a database name.

> Is IS NOT NULL sql server specific, or ANSII compliant?
> And when we start our application we point to a specific database, they can not go to another database within the same session of our application. Do we need to specify the database?
>
>Starting to SQL Server now, so am going to be asking lots of questions over the next month or so at least. :-D
>
>Thanks for the info.
>Beth
>
>