Tue 2 Jan 2018
SQL Server – Find characters in fields
Posted by Internat under SQL, SQL Server
1 Comment
DECLARE @counter int = 1;
DECLARE @colString varchar(10) = 'AA%#& ';
WHILE @counter <= DATALENGTH(@colString)
BEGIN
SELECT CHAR(ASCII(SUBSTRING(@colString, @counter, 1))) as [Character],
ASCII(SUBSTRING(@colString, @counter, 1)) as [ASCIIValue]
SET @counter = @counter + 1
END
GO
Credit to Source
