Sql check if string is empty or whitespace Trim(). Feb 9, 2009 · There are many times were we need to handle NULL and “empty” values in SQL Server. Now I need to move the data to another table and replace the empty spaces with a NULL value. Let’s pull out the NULL values using the IS NULL operator. In the provided sample data, this would include ' Task B ' with an empty string for notes and ' Task C ' with a NULL value for notes. Since NULL value is not the same as empty string in SQL, then the result you obtained is correct and makes sense in SQL terms. Here is a demonstration: declare @tab char(1) = char(9); declare @cr char(1) = char(13) declare @lf char(1) = char(10) Jun 6, 2024 · To catch such rows, we can trim the spaces before checking for empty values: SELECT id, name FROM Department WHERE code IS NULL OR TRIM(code) = ''; The TRIM function removes whitespaces from a string’s beginning and end, allowing us to compare it against an empty character. For bugs like that, probably not important, but you never know. Each has "2. White space is at the start and end of the string. lmcttfslumztslbwvmwwxcxxiafrzqrrpjnwiffymmqfxgurhcvusxxcdyyngjussuxcbuqrxwbl