Skip to Content
0
Former Member
Jan 20, 2016 at 10:15 PM

varchar to int warning while using join

29 Views

Gurus,

I'm joining varchar and integer fields.Due to that, I'm getting varchar to int warning.Tried using Cast in Integer field like below,warning disappears but join doesn't works.I don't want to put one more query transform for converting int to varchar.

A.fieldA=Cast(fieldB as varchar(10))

Kindly help.

Thanks