Hi, Lance:

How about:

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.

Any suggestions?


This thread ...


Return to Archive home page | Return to MIDRANGE.COM home page