We wish to use these pages for publishing various documents, announcements, FAQ etc related to beyondrelational.com...

Don't forget that CHECKSUM can cause collisions. To solve this, use both predicate. SELECT #checksumsTableId FROM #checksumsTable WHERE CHECKSUM('AAFPPFFUFPFPUFPAFAUPFKKAFAKUFAAUK(...cut!)') = checkSumValue AND 'AAFPPFFUFP...

For these case, I have create a table function to split the data on every characters you want : CREATE FUNCTION dbo.F_MULTIPARSE(@PHRASE VARCHAR(max), @PARSEC VARCHAR(256)) RETURNS @T TABLE (POS INT, ...