Thank u very much. What if you have 2 characters to be replaced. i.e. if the value contains both '&' and '<' How do you go about it? -----Original Message----- From: thelist-admin at lists.evolt.org [mailto:thelist-admin at lists.evolt.org]On Behalf Of .jeff Sent: 27 September 2002 13:30 To: thelist at lists.evolt.org Subject: RE: [thelist] & stevenson, ><><><><><><><><><><><><><><><><><><><><><><><><><><><><>< > From: Stevenson Ngila > > [...] coldfussion [...] how can i pick all '&' and > trasform them in to '&'. [...] ><><><><><><><><><><><><><><><><><><><><><><><><><><><><>< Replace(your_db_column_name, "&", "&", "ALL") good luck, .jeff http://evolt.org/ jeff at members.evolt.org http://members.evolt.org/jeff/ -- For unsubscribe and other options, including the Tip Harvester and archive of thelist go to: http://lists.evolt.org Workers of the Web, evolt !