Hey Ratbak,

Thanks again, I tried SELECT CAST('A1-'+CustomerID as text) as CustomerID FROM Customers

Get the message. Conversion failed when converting the varchar value 'C25-' to data type int. Any help would...

Haha, thanks Jeff. Feel a bit better now writing these queries knowing everything will remain unchanged. Just a quick question. I tried the CAST in w3school's sandbox and it worked...

Hey, sorry for the late reply. I did try out your method from SQL Server 2018 R.2 but because my initial column was an integer, it wasn't able to convert...

• This reply was modified 2 years, 10 months ago by  Imrans23.

Awesome. I'm concatenating to a PK field, so I guess I can get away with either. Thank you again! 😀

Hi Grant, Thank you for your kind words of motivation. Looking forward to expand the learning.

Thank you for confirming with me RatBak. appreciate your help