This content has been marked as final. Show 7 replies
I did something to ID, and it's returning as number instead of string. My tbls won't get to join properly because things didn't match.
left(right(ID, 5), 4)+ '0' as NID
left join (tblX)
sql select left(PIN, 9) +'0' as NID
i want to make sure NID is a 5 digit code with ending equal to 0.
ie. '00050' should not be 5