MIDRANGE dot COM Mailing List Archive



Home » MIDRANGE-L » August 2009

Re: Using SQL to select records containing an embedded blank



fixed

Hi, Lance:

How about:

select * from FILENAME where FIELDNAME LIKE '% %'

That should give you what your are looking for.

Cheers,

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?

Thanks,
Lance








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

This mailing list archive is Copyright 1997-2014 by MIDRANGE dot COM and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available here. If you have questions about this, please contact