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
Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.
”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.