Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
Paulo Valentim
Starting Member
2 Posts |
Posted - 2007-04-12 : 09:59:58
|
I would like to know how can i read a ntxt fild and durinng this process i want to extract informations from this field. My situation is this: this field register an html page, and i want to get some informations from this html text. To make it possible i have to read an manipulate this text fild.Does anybody know how to do it?Thanks |
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-04-12 : 10:28:32
|
UPDATETEXT function is useful.Important: This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature. Use the large-value data types and the .WRITE clause of the UPDATE statement instead.Here is an example taken from Books Online. It is little tricky to manipulate text columns in SQL Server.DECLARE @ptrval binary(16)SELECT @ptrval = TEXTPTR(pr_info) FROM pub_info pr, publishers p WHERE p.pub_id = pr.pub_id AND p.pub_name = 'New Moon Books'UPDATETEXT pub_info.pr_info @ptrval 88 1 'b'; Peter LarssonHelsingborg, Sweden |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-04-12 : 10:29:15
|
To extract information, I think you can use SUBSTRING. However, I am not 100% sure.Peter LarssonHelsingborg, Sweden |
|
|
|
|
|