[AccessD] Replace Special Characters

Terri
Check out the Replace function (not in A97 though)

Andy Lacey
http://www.minstersystems.co.uk



> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Terri Jarus
> Sent: 10 April 2003 20:39
> To: accessd at databaseadvisors.com
> Subject: [AccessD] Replace Special Characters
> 
> 
> I want to be able to go through a column of data and strip
> out any special characters (,./"'-*&!, etc.) and store the 
> "clean" data to a new column.
> 
> "ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz1234567890"
> 
> How would I go about doing this?
> 
> Thanks for any help.
> 
> 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/a> ccessd
> Website: 
> http://www.databaseadvisors.com
> 
>