Equate number to varchar

[manmaria]

How do I equate 2 columns from 2 different tables. In one table the same column is defined as dec(9,0) and the other table it is defined as varchar(15)?

Thanks

 

[BillDHS]

You need to cast the decimal a varchar:
Cast(NumericField as VARCHAR(15))

 

[dnoeth]

Or the varchar to a decimal, it depends...

If you simply write "WHERE DecCol = CharCol" the optimizer just casts the Varchar to a float.

Dieter