Gustav Brock
gustav at cactus.dk
Thu Nov 11 05:07:07 CST 2004
Hi Mark and Arthur That may work but you'll be in trouble when trying to switch to design view. I would create a query for Tbl2 with a field with the expression needed to match the Tbl1.Fld1. Then use this query for Tbl1 whenever you need to join Tbl1 and Tbl2. /gustav >>I have two tables I would like to join. Tbl1.Fld1 contains a >>variable-length string, Tbl2.Fld2 contains the same variable-length string >>concatenated with a variable-length suffix. >> >>Any suggestions on how to proceed? Is there an elegant solution? >> >>Mark > At first blush I would try this: > > SELECT * FROM T1 INNER JOIN T2 ON T1.Field1 = Left(T.2.Field1, > LEN(T1.Field1)) > Arthur