Home of the ColdFusion Community
|
Mailing Lists
|
Home /
Groups /
ColdFusion Talk (CF-Talk)
SQL Syntax help
Author: J E VanOver
Short Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:32798#164491
Books Online says:
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 } ]
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
|
May 24, 2012
|
Latest Fusion Authority Articles
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
