Re: How to filter space character ??

2002-01-21 Thread Jenda Krynicky
From: Jay Liam [EMAIL PROTECTED] 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

How to filter space character ??

2002-01-20 Thread Jay Liam
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 andsome has nothing, which i believe space character, not null. Wat I want to do is to be consistent my database. I want to

RE: How to filter space character ??

2002-01-20 Thread Toby Stuart
/\s{1}/null/ look at substitution and regular expressions. hth t0by -Original Message-From: Jay Liam [mailto:[EMAIL PROTECTED]]Sent: Monday, January 21, 2002 3:17 PMTo: [EMAIL PROTECTED]Subject: How to filter space character ?? Hi folks, I got one stupid