linking tables with unmatched fields

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

tachia - 30 Apr 2004 15:06 GMT

I am comparing data from two tables and wanted to create
a field in one table that will only search by the first 6
or 8 characters, because we have some records that are
spelled differently between the two tables. For example,
table1 may say ABC Company and table2 may say ABC Co.

Please let me know how I can create a new col. with just
the first few characters and compare to the other table.

Thanks!

Reply to this Message

Gerald Stanley - 30 Apr 2004 15:53 GMT

Assuming that you have added the new column to your table,
the sql for its population is along the lines of
UPDATE YourTable SET yourNewColumn = Left(yourOldColumn,
noOfChars)

You will have to change YourTable, yourNewColumn and
YourOldColumn to suit your app. noOfChars is a numeric for
the number of characters you want in the new new column.

Hope This Helps
Gerald Stanley MCSD

>-----Original Message-----
>I am comparing data from two tables and wanted to create
[quoted text clipped - 8 lines]
>Thanks!
>.

Reply to this Message