comparing by first few characters of a string in SQL query???

comparing by first few characters of a string in SQL query???

Post by Avi » Fri, 28 Sep 2001 20:29:36



Hi,
   I'm trying to do a select statement where I can compare
info in two joined tables, what i'm trying to do is
compare the first few characters of the string, example:
if 8 chars match, show me, if not then check for 6, if not
then check for 4, etc...

Can anyone help me???

Avi