I am trying to convert an integer to text in a query using:
CASE WHEN [Extension]<'80' THEN '0' + CAST( Extension AS text(12)) ELSE [Extension] END AS Extn
but I get the following error:
'Explicit conversion from data type int to text is not allowed'
Any suggestions? I dont want to convert the Table