There's a great little UDF on cflib.org called DeMoronize that should help you out with this: http://www.cflib.org/udf.cfm?ID=725
I don't know how to grab the infected fields through SQL, but I'd just write a couple queries to accomplish the same thing: grab all records, loop through them, run the UDF on the particular columns and then update the fields. I also added this to the top to pick up some of the funky A's: // remove funky A's Text = Replace(Text, "�", "", "All"); Text = Replace(Text, "�", "", "All"); And the last ReReplace has an extra double quote in it, so ReReplace(Text, ""(^;)", ""\1", "All"); should be ReReplace(Text, "(^;)", ""\1", "All");. Tyler email | [EMAIL PROTECTED] ----- Original Message ----- From: "Tony Weeg" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, November 18, 2002 1:39 PM Subject: sql oddity (repost) hi there. could anyone please tell me how in the heck i can do a dbquery to get all instances of a match of these �?T in that exact string from within a text (Datatype) field full of other data? they are supposed to be 's and for some odd reason, in my cut and paste from word to a text file, then into a textarea formfield, ended up in the db like "driver�?Ts" where that should be "driver's" like "driver's license" anyway, its making life hell right now, and i gotta get em out! thanks. this isnt working... <cfquery name="get1" datasource="acts"> select count(Id) as thisCount from seatBeltLaws where line like '%�?tm%' </cfquery> <cfoutput>#get1.thisCount#</cfoutput> wow its getting late. ..tony tony weeg [EMAIL PROTECTED] www.revolutionwebdesign.com rEvOlUtIoN wEb DeSiGn 410.334.6331 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
