I am not sure how to make a query to take a field called word from tblwords and to add up the combined ascii code numbers.
so if the string in field word is:
then the field AsciiEncode is populated with 674
i did find this on the ms website but not sure how to amalgamate that process into a query.
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)
SELECT ASCII(SUBSTRING(@string, @position, 1)),
CHAR(ASCII(SUBSTRING(@string, @position, 1)))
SET @position = @position + 1
SET NOCOUNT OFF;
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.