Additional scripting for testing the special characters, to be run after the table is populated:

--

-- After creating and populating the table I reduce the number of groups TO 1

--

delete strings where strGroup <> 3

--

-- Create some prepared strings which show special XML Protection

--

delete strings where stringid >= 20 and stringid < 40

SET IDENTITY_INSERT strings ON

insert into strings (stringID,strgroup,string) select 20,3,'ABCDEFG'

insert into strings (stringID,strgroup,string) select 21,3,'less and greater ABC<>DEFG'

insert into strings (stringID,strgroup,string) select 22,3,'ampersand ABC&DEFG'

insert into strings (stringID,strgroup,string) select 23,3,'comma ABC,DEFG'

insert into strings (stringID,strgroup,string) select 24,3,'semicolon ABC;DEFG'

insert into strings (stringID,strgroup,string) select 25,3,'space ABC DEFG'

insert into strings (stringID,strgroup,string) select 26,3,'qoute ABC''DEFG'

insert into strings (stringID,strgroup,string) select 27,3,'double qoute ABC"DEFG'

insert into strings (stringID,strgroup,string) select 28,3,'two double qoutes ABC""DEFG'

insert into strings (stringID,strgroup,string) select 29,3,'<CR><LF> ABC'+CHAR(13)+CHAR(10)+'DEFG'

insert into strings (stringID,strgroup,string) select 30,3,'LF ABC'+CHAR(10)+'DEFG'

insert into strings (stringID,strgroup,string) select 31,3,'CR ABC'+CHAR(13)+'DEFG'

insert into strings (stringID,strgroup,string) select 32,3,'tab ABC'+CHAR(9)+'DEFG'

SET IDENTITY_INSERT strings OFF

Alan has prepared distinct scripts for handling special characters, these additions make some of the differences visible. (I still have to study the behaviour of <CR><LF> and <CR> and <LF> constructions).

Ben