Re: Limited Character Join

From: Mark C. Stock <mcstockX_at_Xenquery>
Date: Thu, 9 Feb 2006 14:13:14 -0500
Message-ID: <1rWdnWmejrzRCXbeRVn-rg@comcast.com>

"tuxfan" <who_at_where.org> wrote in message news:pan.2006.02.09.19.11.06.939572_at_where.org...
> How do I join two column in two tables were I only use the first
> three characters in one of the tables?
>

use substr() -- but if you are joining on a portion of a column, you probably have an incorrectly designed table. typically, you should only be joining on FK and PK (or UK) columns

++ mcs Received on Thu Feb 09 2006 - 13:13:14 CST