Hi Mike
Interesting question, but what about the following records
'Jane measured size 4'
and
'Jane measured size 101'
And
'Jane measured size 12'
Where (in the last one) there are multiple spaces between "size" and "12"?
Alan Shore
Programmer/Analyst, Direct Response
E:AShore@xxxxxxxx
P:(631) 200-5019
C:(631) 880-8640
"If you're going through Hell, keep going" - Winston Churchill
-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Smith, Mike
Sent: Wednesday, December 28, 2011 3:47 PM
To: 'Midrange Systems Technical Discussion'
Subject: finding a value and a subsequent value
I am trying to see if I can do this with sql.
I am searching through comments in a file
I have records like this
'Jane measured size 12'
'Sue called with her size'
So for example purposes lets say I have field ACCT, and COMNT
I want to find records where the word 'size' is in the comment' easy enough,
Select COMNT from MYFILE where COMNT like('%size'%)
But I only want records where there is a number 2 spaces after the word 'size'
Is it possible to do this with an sql statement?
Thanks
Mike
NOTICE: This message, including any attachment, is intended as a confidential and privileged communication. If you have received this message in error, or are not the named recipient(s), please immediately notify the sender and delete this message.
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at
http://archive.midrange.com/midrange-l.
midrange.com
