Convert ASCII to TEXT

%3CLINGO-SUB%20id%3D%22lingo-sub-1558708%22%20slang%3D%22en-US%22%3EConvert%20ASCII%20to%20TEXT%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1558708%22%20slang%3D%22en-US%22%3E%3CP%3EHi%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENew%20to%20SQL%20here%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20table%20with%20a%20column%20that%20have%20ASCII%20codes%20in%20the%20following%20format%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E76%2C%2071%2C%2032%2C%2072%2C%2068%2C%2032%2C%2080%2C%2076%2C%2085%2C%2083%2C%200%2C%200%2C%200%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20do%20i%20convert%20this%20to%20standard%20TEXT.%20Every%20number%20represents%20a%20character%2C%20in%20the%20end%20i%20need%20the%20text%20(without%20the%20commas)%20that%20this%20represents.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20help%20with%20the%20T-SQL%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERegards%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1558708%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EASCII%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ET-Sql%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ETEXT%20convert%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New 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