The code below can be used to obtain a list of the ASCII character codes for each character of a field:
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 |
SET NOCOUNT ON; CREATE TABLE #Characters ( ID INT IDENTITY(1,1) NOT NULL PRIMARY KEY, [Character] NCHAR(1), [ASCIIValue] INT ) DECLARE @counter int = 1; DECLARE @colString NVARCHAR(MAX); SELECT @colString = FIELD --Replace FIELD with your column name FROM dbo.TABLE --Replace TABLE with your table name WHERE ID = 123 --Replace ID with any unique filter WHILE @counter <= DATALENGTH(@colString) BEGIN INSERT INTO #Characters ([Character], [ASCIIValue]) SELECT CHAR(ASCII(SUBSTRING(@colString, @counter, 1))) as [Character], ASCII(SUBSTRING(@colString, @counter, 1)) as [ASCIIValue] SET @counter = @counter + 1 END SELECT * FROM #Characters WHERE ASCIIValue IS NOT NULL ORDER BY ASCIIValue DROP TABLE #Characters SET NOCOUNT OFF GO |
