[AccessD] Remove spaces from field

Replace each occurence of Chr(20) with Null


----Original Message Follows----
From: "Mark Boyd" <MarkBoyd at mcbeeassociates.com>
Reply-To: Access Developers discussion and problem 
solving<accessd at databaseadvisors.com>
To: <AccessD at databaseadvisors.com>
Subject: [AccessD] Remove spaces from field
Date: Thu, 31 Jul 2003 13:44:15 -0400

How can I remove any spaces from data in a field?

For example, Field1 contains 'johnsmith   01/01/1995 ABC'.  I want the
field to be 'johnsmith01/01/1995ABC'.

Any suggestions?



Thanks,

Mark Boyd

Sr. Systems Analyst

McBee Associates, Inc.



_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

_________________________________________________________________
MSN 8 with e-mail virus protection service: 2 months FREE*  
http://join.msn.com/?page=features/virus