G'day Mike, Perhaps it might prefer (char(032)) or even (char(0032))- haven't checked as am about to go to bed after a loooong day.
Regards Clive -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of MikeB Sent: Thursday, 15 July 2004 22:53 To: RBG7-L Mailing List Subject: [RBG7-L] - Re: Searching for spaces on my system: set var vC = (char(32)) bro * fro contactlist where contName cont .vc --- Did Not Work set var vC = (char(160)) bro * fro contactlist where contName cont .vc --- Did Work seems windows, depending on character set uses a different space character. ----- Original Message ----- From: "Paula Stuart" <[EMAIL PROTECTED]> To: "RBG7-L Mailing List" <[EMAIL PROTECTED]> Sent: Thursday, July 15, 2004 7:25 AM Subject: [RBG7-L] - Searching for spaces In earlier versions of RBase, I was able to search (and then globally update) column data based on it containg a blank space. For example, a client database must be modified to include both a first name and middle name field where it now contains a first name field which could contain values of A Raymond or John L As there are nearly ten thousand name records, I was hoping to extract only those which contained the space. This database has the null set to blank and EDIT ALL FROM BIOFILE WHERE FNAME CONTAINS ' ' Returned an error that null values couldn't be searched that way So I changed the null to -0- and tried again and got a different error message <Warning> No rows exist or satisfy the specified clause If a blank space is valid input to a text field, there must be a way to search for it. What am I missing? Paula Stuart
