Nulls and two single quotes

#1

Hi,

does SQL Server see two single quotes as a null?

Thanks

Lee

#2

Lee wrote:

Quote:

Hi,

does SQL Server see two single quotes as a null?

Thanks

Lee
No, two quotes denote an empty string, which is a known value. A NULL is, by

definition, an unknown value.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

comp.databases.ms-sqlserver comp.databases.ms-sqlserver