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


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

Re: Nulls and two single quotes

Path csiph.com!x330-a1.tempe.blueboxinc.net!usenet.pasdenom.info!weretis.net!feeder4.news.weretis.net!eternal-september.org!feeder.eternal-september.org!.POSTED!not-for-mail
From "Bob Barrows" <reb01501@NOyahooSPAM.com>
Newsgroups comp.databases.ms-sqlserver
Subject Re: Nulls and two single quotes
Date Thu, 25 Aug 2011 13:29:30 -0400
Organization A noiseless patient Spider
Lines 12
Message-ID <j360v2$1r8$1@dont-email.me> (permalink)
References <6a725e55-cf44-4f31-aa2e-098ebe415737@n12g2000yqh.googlegroups.com>
Injection-Date Thu, 25 Aug 2011 17:32:19 +0000 (UTC)
Injection-Info mx04.eternal-september.org; posting-host="NUmboHSNYG4cX5Ys9j8TNw"; logging-data="1896"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX190eEDOmhR5jKiFuq1Kfdt4q0yQReYZg3k="
X-MimeOLE Produced By Microsoft MimeOLE V6.00.2800.2001
X-Newsreader Microsoft Outlook Express 6.00.2800.2001
Cancel-Lock sha1:3xY3yMkQLarCJ8jhwycGRcytDbs=
X-Priority 3
X-MSMail-Priority Normal
Xref x330-a1.tempe.blueboxinc.net comp.databases.ms-sqlserver:628

Show key headers only | 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