UPDATETEXT
Updates an existing text, ntext, or image field. Use UPDATETEXT to change
only a portion of a text, ntext, or image column in place. Use WRITETEXT to
update and replace an entire text, ntext, or image field.
Does that include <long text> ???
Syntax
UPDATETEXT { table_name.dest_column_name dest_text_ptr }
{ NULL | insert_offset }
{ NULL | delete_length }
[ WITH LOG ]
[ inserted_data
| { table_name.src_column_name src_text_ptr } ]
-----Original Message-----
From: Jeff Waris [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 26, 2004 10:29 AM
To: CF-Talk
Subject: OT: SQL Syntax help
What is the syntax for the updatetext() function in SQL 7. What I need to do
is replace all occurrences of a word with another word inside a <long text>
field. I have two SQL books and neither explain this fully. Google hasn't
been of much help either. On that note, is there any way in enterprise
manager or SQL analyzer to edit data in the <long text> field??
Thanks!
Jeff
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
