I have troubles reading the content of a field in a table which is
of the datatype text.

Function like Substring or Pathindex do not return correct informations back.
The content in the attribut is xml or html and I am able
to verify the content using a virtual directory in IIS.
If I do something like a select textattribut from table for xml auto, I can see its content.
A select substring(attribut, 1, 20) from table returns only '< '
regardless of the start length.

I would like to find a certain string pattern in the text and insert
2 lines of text with a sql command. Any ideas?