Wildcards in varchar column

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 - 08:50:18 CDT