RE: use of _ in sql on i5

Had some fun but gave up.

SELECT SRCDTA, locate('6D40', hex(srcdta)), SRCDTA, substr(SRCDTA,
locate('6D40', hex(srcdta))) FROM foxwell/A1 WHERE hex(srcdta) like
'%6D40%'

Here, I'm looking for the characters '_ ' but what if the characters before or after end with HEX 6 or begin with HEX 0, I will select HEX D4 instead of HEX 6D.

Also, LOCATE won't work like that, of course.

-----Message d'origine-----
De : midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] De la part de rob@xxxxxxxxx
Envoyé : jeudi 22 janvier 2009 16:25
À : Midrange Systems Technical Discussion
Objet : Re: use of _ in sql on i5

What the hex are you asking?

clue given :-)

Rob Berendt
--
Group Dekko Services, LLC
Dept 01.073
Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





From:
David FOXWELL <David.FOXWELL@xxxxxxxxx>
To:
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Date:
01/22/2009 10:11 AM
Subject:
use of _ in sql on i5
Sent by:
midrange-l-bounces@xxxxxxxxxxxx



I changed all my "@" to "_" in a source file.

How d'you select character strings containing "_" ?

Is "_" some kind of wild card?


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



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