Compare Page Revisions
« Older Revision - Back to Page History - Current Revision
See:Dick:and:Jane:run
declare @Input varchar(500) ,@doc xml select @Input = 'See:Dick:and:Jane:run' ,@doc = convert(xml, '<x v="' + replace(@Input, ':', '"/><x v="') + '"/>') select v = T.c.value('.', 'varchar(100)') from @doc.nodes('x/@v') T(c)
declare @Input varchar(500) ,@s varchar(500) ,@doc xml select @Input = 'See Dick say to the A&P clerk, "Hello, there."' ,@s = replace(@Input, '&', '&') ,@doc = convert(xml, '<x><v>' + replace(@s, ' ', '</v></x><x><v>') + '</v></x>') select v = T.c.value('.', 'varchar(100)') from @doc.nodes('x/v') T(c)
ScrewTurn Wiki version 3.0.1.400. Some of the icons created by FamFamFam. Except where noted, all contents Copyright © 1999-2024, Patrick Jasinski.