Re: sql scan for special characters

[Michael Ryan <michaelrtr@xxxxxxxxx>]

Jim...I think you need to escape out those characters. Here's a post:
http://archive.midrange.com/midrange-l/200901/msg00852.html

On Fri, Apr 2, 2010 at 2:30 PM, Jim Franz <franz400@xxxxxxxxxxxx> wrote:

> Ampersand is the only one that works for me in a "like".
> The underscore and percent both return all records
> Jim
>
> ----- Original Message -----
> From: "Alan Shore" <AlanShore@xxxxxxxx>
> To: "Midrange Systems Technical Discussion" <midrange-l@xxxxxxxxxxxx>
> Sent: Friday, April 02, 2010 1:43 PM
> Subject: Re: sql scan for special characters
>
>
>
> You are in fact correct - you use like
> For example
> like '%&%'
>
> You are looking for the character &
> The delimiters are %
> There is a way to look for % but the delimiters have to be defined as
> something else
> I used this once MANY moons ago. My memory is not as good as it once was
> (if ever)
>
>
>
> 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
>
>
>
>             "Jim Franz"
>             <franz400@xxxxxxx
>             r.com>                                                     To
>             Sent by:                  <MIDRANGE-L@xxxxxxxxxxxx>
>             midrange-l-bounce                                          cc
>             s@xxxxxxxxxxxx
>                                                                   Subject
>                                       sql scan for special characters
>             04/02/2010 01:08
>             PM
>
>
>             Please respond to
>             Midrange Systems
>                 Technical
>                Discussion
>             <midrange-l@midra
>                 nge.com>
>
>
>
>
>
>
> How does one scan for special characters in a field with sql?
> Need to find percent sign - %, ampersand - &, and underscore - _
> Could be in any position within a field.
> Is there perhaps a way to do a like with a hex value?
> Jim Franz
> --
> 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.
>
> --
> 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.