Selecting partial match between two fields

[wdbouk]

Hello,
I have two columns one with 9 character and the other with 8. I want to match the two columns where the first 8 characters of both matched.
I used the following:

SELECT FinancialQ.*, IssueM.*
FROM FinancialQ LEFT JOIN IssueM ON FinancialQ.Cusip = IssueM.Expr1000
WHERE ON LEFT( FinancialQ .Cusip,8)=LEFT(IssueM.Expr1000,8) ;

but I receive syntax error (missing operator)in query expression 'ON LEFT( FinancialQ .Cusip,8)=LEFT(IssueM.Expr1000,8)'

Any hint of where i made the mistake?

 

[PHV]

Have you tried this ?
SELECT FinancialQ.*, IssueM.*
FROM FinancialQ LEFT JOIN IssueM
ON LEFT(FinancialQ .Cusip,8)=LEFT(IssueM.Expr1000,8)
;


Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[wdbouk]

invalid use of .,!or())in query expression 'ON LEFT( FinancialQ .Cusip,8)=LEFT(IssueM.Expr1000,8)

 

[PHV]

Replace this:
FinancialQ .Cusip,8
By this:
FinancialQ.Cusip,8

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[wdbouk]

Yes it works
the mistake was so small
thx