×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
Select *
From MyTable
Where Posstr(Trim(MyFld): ' ') > 0
Mit freundlichen Grüßen / Best regards
Birgitta Hauser
"Shoot for the moon, even if you miss, you'll land among the stars." (Les
Brown)
"If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them? Not training them
and keeping them!"
-----Ursprüngliche Nachricht-----
Von: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] Im Auftrag von Lance Gillespie
Gesendet: Thursday, 13. August 2009 16:58
An: midrange-l@xxxxxxxxxxxx
Betreff: Using SQL to select records containing an embedded blank
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
midrange.com
