Trying to join two views that have different column types

I suggest to JOIN two views based on varchar column rather than trying to get varchar into integer, e.g.

from View1 INNER JOIN View2 ON View1.Region_City =

RIGHT('0000'+CAST(View2.Region as varchar(4)),4) + RIGHT('0000' + CAST(View2.City as varchar(4)),4)

---

For every expert, there is an equal and opposite expert. - Becker's Law





My blog



My TechNet articles