Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.
I am just experimenting with an idea, i may at some stage need to store those codes in a field 77-121-32-119-111-114-100 but i am not sure yet.
SET TEXTSIZE 0; SET NOCOUNT ON; -- Create the variables for the current character string position -- and for the character string. DECLARE @position int, @string char(15); -- Initialize the variables. SET @position = 1; SET @string = 'Du monde entier'; WHILE @position <= DATALENGTH(@string) BEGIN SELECT ASCII(SUBSTRING(@string, @position, 1)), CHAR(ASCII(SUBSTRING(@string, @position, 1))) SET @position = @position + 1 END; SET NOCOUNT OFF; GO