Paula, Try:
EDIT ALL FROM BIOFILE WHERE FNAME LIKE '% %' Bill On 15 Jul 2004 at 8:25, Paula Stuart wrote: > 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 ' '
