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
