How to check for null/empty/whitespace values with a single test?

-
The NULLIF function will convert any column value with only whitespace into a NULL value. Works for T-SQL and SQL Server 2008 & up.
SELECT [column_name]
FROM [table_name]
WHERE NULLIF([column_name], '') IS NULL

Comments

Post a Comment

Popular posts from this blog

Validate Email Address in Two Ways

-
This is a little code example that will validate an email address in two ways: - first the general syntax of the string is checked with a regular expression - then the domain substring (after the '@') is checked using the 'checkdnsrr' function function  validate_email ( $email ){     $exp  =  "^[a-z\'0-9]+([._-][a-z\'0-9]+)*@([a-z0-9]+([._-][a-z0-9]+))+$" ;    if( eregi ( $exp , $email )){       if( checkdnsrr ( array_pop ( explode ( "@" , $email )), "MX" )){         return  true ;       }else{         return  false ;       }    }else{       return  false ;    }    } ?>
Read more

From the Experts

-
IF WE CANNOT LOVE THE PERSON WHOM WE SEE,... HOW CAN WE LOVE GOD,WHOM WE CANNOT SEE ? - MOTHER THERESA . IF YOU WIN YOU NEED NOT EXPLAIN .......... BUT IF YOU LOSE YOU SHOULDNOT BE THERE TO EXPLAIN - ADOLPH HITLER IF YOU START JUDGING PEOPLE YOU WILL BE HAVING NO TIME TO LOVE THEM - MOTHER THERESA I'M NOT IN COMPETITION WITH ANYBODY BUT MYSELF.......... MY GOAL IS TO BEAT MY LAST PERFORMANCE - BILL GATES DON'T COMPARE YOURSELF WITH ANYONE IN THIS WORLD.......IF YOU DO SO, YOU ARE INSULTING YOURSELF - ALEN STRIKE . NEVER EXPLAIN YOURSELF TO ANYONE.......BECAUSE THE PERSON WHO LIKES YOU DOES NOT NEED IT.........AND THE PERSON WHO DISLIKES YOU WON'T BELIEVE IT - AUTHOR UNKNOWN THE DREAM IS NOT WHAT YOU SEE IN SLEEP......DREAM IS WHICH DOES NOT LET YOU SLEEP. - DR. ABDUL KALAM (Former President of the Republic of India) NO MAN IS RICH ENOUGH TO BUY HIS PAST - - OSCAR WILDE IF YOU WANT REAL PEACE,.... DON'T TALK TO YOUR FRIENDS,...TALK WITH YOUR ENEMIES - MOTHER THERESA WI...
Read more

Xampp MySQL not starting

-
Image
  If changing port number doesn't solve your problem, follow steps and this solves problem: (** By these steps don't need to reinstall Xampp or loss your database**) Stop all Xampp services and exit application. Move to c:\xampp\mysql Rename data folder to data_old create new data folder and copy whole content of backup folder to the data folder except "ibdata1"  5) Select all files in data_old folder and paste into data folder ( Note  Don't replace copied files and skip replace theme).
Read more