Convert ASCII to TEXT

Copper Contributor



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






0 Replies