RE: finding a value and a subsequent value

Thanks Steve,

I don't think that will work because it could be
'Sue called with her size five'
In this case I wouldn't want the record. I only want it if is numeric.

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of sjl
Sent: Wednesday, December 28, 2011 3:54 PM
To: midrange-l@xxxxxxxxxxxx
Subject: Re: finding a value and a subsequent value

Mike -

Specify the trailing spaces in your LIKE clause.

However, I might do it this way to catch anything entered in the comments
field in mixed case:

Select COMNT from MYFILE where UPPER(COMNT) like('%SIZE %')

Regards,
Steve


Mike wrote:
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?

--
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.

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.