AW: SQL find "+" in a string

["BirgittaHauser" <Hauser@xxxxxxxxxxxxxxx>]

Hi,

IMHO 
Like X'6C4E6C'
Is not the correct syntax.

In either way I'd add the % sign before and after the string. 
The following syntax should always work:

Select *
  From MyTable
  Where MyCol like '%' concat x'6C4E6C' concat '%' 


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 Ron Adams
Gesendet: Wednesday, April 04, 2007 23:41
An: Midrange Systems Technical Discussion
Betreff: Re: SQL find "+" in a string


My bad again. The character(s) that are getting into the field are actually
not visible/hex characters.



On 4/4/07, Elvis Budimlic <ebudimlic@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
> <snip> But, it makes me wonder how it would work using *STD rules. 
> </snip>
>
> Why doesn't LIKE '%+%' work?
>
> Elvis
>
> Celebrating 10-Years of SQL Performance Excellence
>
> -----Original Message-----
> Subject: Re: SQL find "+" in a string
>
>
> --
> 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.