RE: How to filter space character ??

[Rick Miske]

update table_name set column_name = null where column_name = ' ' or column_name = ''       -----Original Message----- From: Jay Liam [mailto:[EMAIL PROTECTED]] Sent: Sunday, January 20, 2002 9:17 PM To: [EMAIL PROTECTED] Subject: How to filter space character ?? Hi folks,   I got one stupid question.  I am facing problem by filtering record from my MS SQL database on Windows2000.  For one column, some of my records has NULL value and some has nothing, which i believe space character, not null.   Wat I want to do is to be consistent my database.  I want to change all of my space character with NULL value.  Any of you guys can suggest me how to write update query to replace all the space column with NULL value.  I tried but I couldn't get the space value.     Thanks a bunch..   Regards, Jay