Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Wildcards in varchar column
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...Received on Tue May 27 2003 - 09:23:50 CDT
> 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
>
>