Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > comp.databases.ms-sqlserver > #628

Re: Nulls and two single quotes

From "Bob Barrows" <reb01501@NOyahooSPAM.com>
Newsgroups comp.databases.ms-sqlserver
Subject Re: Nulls and two single quotes
Date 2011-08-25 13:29 -0400
Organization A noiseless patient Spider
Message-ID <j360v2$1r8$1@dont-email.me> (permalink)
References <6a725e55-cf44-4f31-aa2e-098ebe415737@n12g2000yqh.googlegroups.com>

Show all headers | View raw


Lee wrote:
> 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.

Back to comp.databases.ms-sqlserver | Previous | NextPrevious in thread | Find similar


Thread

Nulls and two single quotes Lee <lee.jenson@live.co.uk> - 2011-08-25 09:30 -0700
  Re: Nulls and two single quotes "Bob Barrows" <reb01501@NOyahooSPAM.com> - 2011-08-25 13:29 -0400

csiph-web