--select contentid,config,cast(config as xml) xConfig from contents -- Check to see if there are any XML conversion issues. -- select max(cast(cast(config as xml) as varchar(max))) test from Contents -- Check for erronious PSI Data select * from Contents where Config like '%' from Contents where Config like '%