Posted by Luuk on 08/22/07 07:13

>>
>> SELECT * from table where name<>"" and employeeId<>0 and email<>"";
>
> Just a note:
>
> Please, no double quotes for string constants, use single quotes.
>
> Double quotes are reserved for "delimited identifiers" as defined by the
> SQL Standard and supported by MS SQL Server.
>

I tend to forget those things, as its different in every programming
evironment i use....
some of the don't care, some use double quotes, and some use single
quotes...

thanks anyway for this reminder....

[Back to original message]