Convert column value
Select * From mdCvlibrary cv Inner Join mdJobDetails jd On Cast(jd.Reference As varchar(200)) = Cast(cv.JobRef As varchar(200)) Inner Join mdCustomerAdvert ca On ca.AdvertId = jd.AdvertId Where Title = 'Unity VR Developer'