... 3) AS EmployeeNo,
RIGHT('000' + CAST(q.Employee AS VARCHAR), 3)
+ '01' AS QualificationRef
FROM
Qualifications q
INNER JOIN Employee e
ON RIGHT('000' + CAST(e.ID AS VARCHAR), ...
We use cookies to improve your experience on our website. By browsing this website, you agree to our use of cookies. Read more about our Privacy Policy.