Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: SQL
Expertise: Beginner
Apr 12, 2018

WEBINAR:

On-Demand

Application Security Testing: An Integral Part of DevOps


How to Check for a NULL Value and an Empty String

You may need to check address fields (for example) for a NULL value or an empty string (the value looks null, but simply contains an empty string - which is still technically a value).

The query below checks for null values, as well as empty strings, then provides a suitable replacement on either occasion.

SELECT  TABLE.ID, 
            ISNULL(NULLIF(TABLE.Address, ''), 'No Address') [Address]
    FROM    [dbo].[TABLE]
Hannes du Preez
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date