|
/\s{1}/null/
look
at substitution and regular expressions.
hth
t0by
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
|
