SDU Tools 119 Convert Blank Strings or Zeros to NULL in T-SQL
SDU Tools are free tools and example T-SQL code for SQL Server developers and DBAs. The first of these functions returns a NULL string if the string contains no characters, else trims the string. The second function returns NULL if the value is zero.
To join SDU Insiders and get all our free resources, including SDU Tools, see the details at http://sdutools.sqldownunder.com