Join Problem

HI All,

I am trying to join 2 tables in a select clause where the primary key of the master is say

123456

and the secondary table has a column (not the primary column) where it is made up of the form

RDS123456A Where 123456 corresponds to the primary key of the Master.

I thought that joining using

t1.Key innerJOIN
dbo.RPA_DAT rp ON substring(rp.DAT, 4, 6)

but SQL Server doesn't like it

Are all the records primary key 6 in length and if not do you pad in the other table? Also what is the error you are getting?

Thanks for looking, I have managed to resolve this. Part of the prob was that I needed to perform a Cast on one of the columns.