Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Wildcards in varchar column

Re: Wildcards in varchar column

From: Jim Kennedy <kennedy-down_with_spammers_at_attbi.com>
Date: Tue, 27 May 2003 14:23:50 GMT
Message-ID: <WxKAa.480670$Si4.413228@rwcrnsc51.ops.asp.att.net>


Standard SQL-> % = * and _ = ?
Jim

-- 
Replace part of the email address: kennedy-down_with_spammers_at_attbi.com
with family.  Remove the negative part, keep the minus sign.  You can figure
it out.
"Hendrik Lampert" <henhouse_at_gmx.net> wrote in message
news:bavqj0$c9d$04$1_at_news.t-online.com...

> Hi,
>
> i want to compare varchar fields of 2 tables.
>
> Content of Field_A table A: ?bc?e*
> Content of Field_B table B: abcdefghi
>
> Result should be: Field_A matches Field_B
>
> The characters of Field_A should be interprated as wildcards '?' (one
char)
> and '*' (anything else).
>
> Many thanks for help.
>
> Regards
> Hendrik
>
>
Received on Tue May 27 2003 - 09:23:50 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US