RE: Replacing text on query..

2003-06-23 Thread Nick Stuart
Thanks for pointing that one out. Unfortunately relplace(table.*, ...) does not work (syntax error) so I'll stil have to go through each field individually. This will be two statements per-field which kinda stinks, but oh well. Thanks again! -Nick On Mon, 2003-06-23 at 11:10, Mike Hillyer wrote:

RE: Replacing text on query..

2003-06-23 Thread Mike Hillyer
Take a look at the REPLACE() function: http://www.mysql.com/doc/en/String_functions.html#IDX1202 Regards, Mike Hillyer www.vbmysql.com > -Original Message- > From: Nick Stuart [mailto:[EMAIL PROTECTED] > Sent: Monday, June 23, 2003 8:58 AM > To: MySQL List > Subject: Replacing text on q