RE: [ACFUG Discuss] Data Update

2006-12-09 Thread Charlie Arehart
Ben, are you saying that the Replace T-SQL function that Teddy mentioned won't work for the problem Michael raised (since he specifically said he needed to update a Text column datatype? That would certainly put the skids on the approach. :-) I've not faced the problem at all myself so was just hel

Re: [ACFUG Discuss] Data Update

2006-12-09 Thread Ben Johnson
Just remember that REPLACE won't work on text fields. Varchar, yes. On 12/8/06, Charlie Arehart <[EMAIL PROTECTED]> wrote: To clarify, as is clear from the example, Teddy has shown there the T-SQL way of doing the replace (he doesn't mean the CFML Replace function), which would mean either do