Depending on which database engine you use, you might be able to do an srpl in your select statement and have your DB engine replace all the characters for you.
Or, if you want it out of the data stored in the DB you could do an update with srpl to replace all extended chars with more sane chars. ----- Original Message ----- From: "John Newsom" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, August 05, 2004 4:32 PM Subject: Witango-Talk: Replace special characters in a resultset We have a resultset from a sql server query that contains foreign letters such as umlauts, etc. These are fouling up our active directory. We'd like to do a search and replace on the resultset. It there a way to replace all occurances in an entire result at once without doing iterations, or rows loops? Thanks, John Newsom Lakeside School ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
