By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,346 Members | 2,158 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,346 IT Pros & Developers. It's quick & easy.

Function to remove zero-length strings in MS SQL

P: n/a
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.

Aug 16 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
bf*****@gmail.com wrote:
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.
This will do it:

UPDATE TableX SET ColumnY = NULL Where TableX.ColumnY = "";

--
Smartin
Aug 16 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.