Mega Code Archive
TEXTPTR function
<![CDATA[
5> CREATE TABLE pub_info
6> (
7> pub_id char(4) NOT NULL,
8> logo image NULL,
9> pr_info text NULL
10> )
11>
12> insert pub_info values('1756', 0x4749,'This is sample text.')
13> GO
1>
2> -- WRITETEXT with an unprotected text pointer
3> DECLARE @mytextptr varbinary(16)
4> SELECT @mytextptr=TEXTPTR(pr_info)
5> FROM pub_info WHERE pub_id='9999'
6> IF @mytextptr IS NOT NULL
7> WRITETEXT pub_info.pr_info @mytextptr 'Hello Again'
8> GO
1>
2> drop table pub_info;
3> GO
1>
]]>