select * from FILENAME where FIELDNAME LIKE '% %'
That should give you what your are looking for.
Mark S. Waterbury
Lance Gillespie wrote:
Is it possible to use interactive sql on the i to find records where
a particular field contains embedded blanks?
I mean one or more non-blanks followed by one or more blanks
followed by one or more non-blanks.
I can do it with an RPG program, of course, but am trying to learn
to use sql where appropriate.