Datatype ntext

[fcela]

Hallo. I need help, how pull out some inquiry string from type "ntext" in MS SQL(it is xml document). Sring has invariable length, in note is always on other position and includes variable text (e.g .:<actionId>xx</actionId>) . Position I can find out by the help of "patindex" but I don't know what then. I tryed to write procedures, but I had trouble with declaration variables (data type). Thanks and sorry for my horrible English.

[skhanal]

See sp_xml_preparedocument in books online, this allows you to run SELECT queries on xml document.

[fcela]

But I have about 500 000 lines with xml files and i need a string from every one line ...

[rmiao]

Possible to use full text index?

[fcela]

Maybe. I don't know how

[rmiao]

You can find details in sql books online by searching 'full text index'.

[fcela]

Thanks, I am doing it for last three days