Re: use of _ in sql on i5

[Michael Ryan <michaelrtr@xxxxxxxxx>]

Yes it is. You need to escape it if you want to use it. I would try to
avoid that character as well as '%'. Here's an example of how to
escape in interactive SQL:

UPDATE IMAGES SET IMAGES.SEQUENCE = 3
WHERE (((IMAGES.FILENAME) LIKE '%FIN_*_%' escape '*') AND
((IMAGES.MFPARTNUMBER) LIKE 'COLL-%'));

Here I'm using '*' as the escape character because I have to search
for an underscore.

On Thu, Jan 22, 2009 at 10:09 AM, David FOXWELL <David.FOXWELL@xxxxxxxxx> wrote:
> 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.