Re: SQL Wildcarding

[Charles Wilt <charles.wilt@xxxxxxxxx>]

This should work, but will result in a full scan...so performance may
be horrid...

Charles

On Fri, Apr 8, 2011 at 2:40 PM, Tyler, Matt <matt.tyler@xxxxxxxxxxxxxx> wrote:
> Try the REPLACE() function
>
> Dynamic statement:
> Stmt += 'Where TrimReplace(dbphn ,'() -')) = ''' +%Trim(Hostphn) +''''
>
>
> Thanks, Matt
>
> -----Original Message-----
> From: midrange-l-bounces@xxxxxxxxxxxx
> [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of
> midrange-l-request@xxxxxxxxxxxx
> Sent: Friday, April 08, 2011 12:25 PM
> To: midrange-l@xxxxxxxxxxxx
> Subject: MIDRANGE-L Digest, Vol 10, Issue 587
>
> Send MIDRANGE-L mailing list submissions to
>        midrange-l@xxxxxxxxxxxx
>
> To subscribe or unsubscribe via the World Wide Web, visit
>        http://lists.midrange.com/mailman/listinfo/midrange-l
> or, via email, send a message with subject or body 'help' to
>        midrange-l-request@xxxxxxxxxxxx
>
> You can reach the person managing the list at
>        midrange-l-owner@xxxxxxxxxxxx
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of MIDRANGE-L digest..."
> --
> 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.