Re: Function to check NULL and Empty String
From: Jeff Dillon (jeff_at_removeemergencyreporting.com)
Date: 10/20/04
- Next message: John: "RE: update X rows of column"
- Previous message: Anith Sen: "Re: Select question"
- In reply to: David Portas: "RE: Function to check NULL and Empty String"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 20 Oct 2004 09:11:27 -0700
Perfect! I thought I was missing something simple.
thx
Jeff
"David Portas" <REMOVE_BEFORE_REPLYING_dportas@acm.org> wrote in message
news:9C66DE55-C61D-4D7C-8F89-238F636A4D2B@microsoft.com...
> IS NOT NULL isn't needed in the code you posted anyway (NULLs will be
> excluded by <> '')
>
> IF @infodate>''
> (not NULL and not empty)
>
> IF NULLIF(@infodate,'') IS NULL
> (NULL or empty -- but I would probably prefer to achieve this just by
> swapping the IF and ELSE parts in the above)
>
> --
> David Portas
> SQL Server MVP
> --
>
- Next message: John: "RE: update X rows of column"
- Previous message: Anith Sen: "Re: Select question"
- In reply to: David Portas: "RE: Function to check NULL and Empty String"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
