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
One Response to “ SQL Server – Find characters in fields ”
Trackbacks & Pingbacks:
plexus 3.1.3 Crack
Our-files.com