DB SQL to ASCII interpretation

I decided to add this forum to keep track of solutions for DB related problems.
I have worked with some brilliant people in my life and the solutions to issues that are usually beyond something you can get at Jack in Box Jackson. They deserve historical marker. This is the historical marked on my map.
Pouzivej data base
Post Reply
hudatolah
Site Admin
Posts: 152
Joined: Thu Apr 04, 2013 8:10 pm
Are You a Headhunter?: Affirmative
Surfer?: Yes

DB SQL to ASCII interpretation

Post by hudatolah » Sat Jan 25, 2020 11:52 am

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/
The Blackholesurfer. My surfboard has teeth.
Top
Post Reply

Return to “Database References”