>-----Original Message----- >From: Keith Clark [mailto:[EMAIL PROTECTED] >Sent: Wednesday, October 29, 2008 04:16 PM >To: [email protected] >Subject: Re: [users] Base field alter > >Barbara Duprey wrote: >> Keith Clark wrote: >>> norseman wrote: >>>> Keith Clark wrote: >>>>> I need to remove all ACII 13 characters from a field in a >>>>> database. Each entry could have multiple ASCII 13 characters. Is >>>>> there a way to do this? >>>>> >>>>> <snip> >>>> >>>> Without knowing the OS, the specific database and such, that is the >>>> best I can offer. >>>> >> >> >mysql remote database. >
MySQL ( and pretty much every other SQL database) supports the REPLACE function, see: http://dev.mysql.com/doc/refman/5.0/en/string-functions.html#function_replace As Ms. Duprey mentioned in an earlier response in order to use this in an UPDATE statement, under Base, you will need to do so in the SQL window. 'Tools>SQL'. To look for the ASCII 13 character you will use the function CHAR(13) - so to replace ASCII 13 with a SPACE the command will be something similar to UPDATE 'your_table' SET 'your_column' = REPLACE( 'your_column', CHAR(13), ' ' ); HTH Drew --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
