Convert ASCII to TEXT

Copper Contributor

Hi

 

New to SQL here

 

I have a table with a column that have ASCII codes in the following format

 

76, 71, 32, 72, 68, 32, 80, 76, 85, 83, 0, 0, 0

 

How do i convert this to standard TEXT. Every number represents a character, in the end i need the text (without the commas) that this represents.

 

Please help with the T-SQL

 

Regards

 

 

 

0 Replies