UPDATE TableName SET ColumnName = Replace(ColumnName, " " , "")
NOTE: This will update all records. If you need to filter, add a WHERE clause. -----Original Message----- From: Jim McAtee [mailto:[EMAIL PROTECTED] Sent: Monday, January 03, 2005 3:48 PM To: CF-Talk Subject: Access SQL - Strip Spaces? I have a small app in Access and I need to remove spaces from a field from within the SQL. What is the appropriate function call? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Special thanks to the CF Community Suite Silver Sponsor - RUWebby http://www.ruwebby.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189177 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
