Re: How to "cast" a column ?

2007-01-30 Thread Nils Meyer
Hi Manuel, Manuel Vacelet wrote: I have query that joins 2 tables. I have an index on each part of the join but unfortunately the 2 columns don't have the same type so the index is not used for the join (I guess it's the reason why). On one hand I have an INT and on the other and a VARCHAR. This

How to "cast" a column ?

2007-01-30 Thread Manuel Vacelet
Hi all, I have query that joins 2 tables. I have an index on each part of the join but unfortunately the 2 columns don't have the same type so the index is not used for the join (I guess it's the reason why). On one hand I have an INT and on the other and a VARCHAR. Is there any way to write the