|
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 | 
