Function to remove zero-length strings in MS SQL

Giganews Newsgroups
Subject: Function to remove zero-length strings in MS SQL
Posted by:  bfaus…@gmail.com
Date: 15 Aug 2006

Is there an inbuilt function within MSSQL that converts zero-length
strings to nulls? Or do I have  to create a custom built function.

I am having issues with these zero-length strings as I develop allot
with an MS Access frontend and MSSQL backend.

Thanks in advance.

Replies