[Tarkon]

Hi,

I have two tables that I need to join together for a query - the problem is that in one table the column MAY have a leading zero (if it's 4 characters long), and the other table will never have a leading zero.

An example:

Table1          Table2
----------------------
04232     |       4232
50292     |      50292
03211     |       3211
06843     |       6843

I was thinking of doing something along the lines of

LEFT JOIN Table2 ON
Table2.Column1 LIKE %Table1.Column1

But I don't think that's possible. Could anyone help me out?

Thanks!
-T

[anacedent]

what are the datatype for the two columns?
it appear you are storing numbers in a VARCHAR2 field in Table1

[Tarkon]

It's VARCHAR2 since sometimes they're alphanumeric.

Originally Posted by anacedent

what are the datatype for the two columns?
it appear you are storing numbers in a VARCHAR2 field in Table1

[AlanP]

Yep you can use like for a join i.e.

select *
from a, b
where a.col1 like '%'||b.col2

Alan

[beilstwh]

or if the leading zero the only issue

select *
from a, b
where a.col1 = ltrim(b.col2,'0');