REPLACE
Replaces all occurrences of the second given string expression in the first
string expression with a third expression.
Syntax
REPLACE *( '**string_expression1**' , '**string_expression2**' , '**
string_expression3**' )*
Arguments
*'**string_expression1**'*
Is the string expression to be searched. *string_expression1* can be of
character or binary data.
*'**string_expression2**'*
Is the string expression to try to find. *string_expression2* can be of
character or binary data.
*'**string_expression3**'*
Is the replacement string expression *string_expression3 *can be of
character or binary data.
Return Types
Returns character data if *string_expression *(1, 2, or 3)* *is one of the
supported character data types. Returns binary data* *if *string_expression
*(1, 2, or 3)* *is one of the supported *binary* data types.
Examples
This example replaces the string cde in abcdefghi with xxx.
SELECT REPLACE('abcdefghicde','cde','xxx')
GO
Here is the result set:
------------
abxxxfghixxx
(1 row(s) affected)
On 12/8/06, Singles Concepts, Inc. <[EMAIL PROTECTED]> wrote:
Happy Holidays Fellow CF Fans,
Does know how to change data in a MSSQL text field. I have a single word
that I need to do a Search and Replace on. I just want to update a single
word inside a paragraph.
Any help would be great.
Michael B
--
<cf_payne />
Adobe Certified ColdFusion MX 7 Developer
Atlanta CFUG (ACFUG): http://www.acfug.org
-------------------------------------------------------------
To unsubscribe from this list, manage your profile @
http://www.acfug.org?fa=login.edituserform
For more info, see http://www.acfug.org/mailinglists
Archive @ http://www.mail-archive.com/discussion%40acfug.org/
List hosted by http://www.fusionlink.com
-------------------------------------------------------------
