www.blackholesurfer.com • DB SQL to ASCII interpretation

Page 1 of 1

DB SQL to ASCII interpretation

Posted: Sat Jan 25, 2020 11:52 am

by hudatolah

Code: Select all

declare @string nvarchar(128)
select @string  = (SELECT TOP 1 from TABLE where CONDITION)

; with allNumbers as
(
select 1 as number
union all
select number+1
from allNumbers
where number<len(@string)
)
select substring(@string,number,1), ascii(substring(@string,number,1)),* from allNumbers

Mapping:
http://www.asciitable.com/