CHAR Übersetzung in SQL String finden
SET TEXTSIZE 0; — Create variables for the character string and for the current — position in the string. DECLARE @position INT, @string CHAR(8); — Initialize the current position and the string variables. SET @position = 1; SET @string = ‘New Moon’; WHILE @position <= DATALENGTH(@string) BEGIN SELECT ASCII(SUBSTRING(@string, @position, 1)), CHAR(ASCII(SUBSTRING(@string, @position, 1))) SET @position = @position + 1 END; GO
https://www.mssqltips.com/sqlservertip/6022/sql-server-char-function-and-reference-guide/
mit der ASCII (String) Funktion kann man den CHAR wert eines Zeichens ermitteln.
https://www.tutorialspoint.com/sql/sql-string-functions-ascii.htm#:~:text=Returns%20an%20integer%20value%2C%20based,fields%20in%20an%20SQL%20table.