>From a little more research I found that Access 2000 only supports a subset of the ODBC scalar functions, and REPLACE() isn't supported. So, unless someone knows of another way, I guess I'll just do it in CF after the query is executed.
----- Original Message ----- From: "Jim McAtee" <[EMAIL PROTECTED]> To: "CF-Talk" <cf-talk@houseoffusion.com> Sent: Monday, January 03, 2005 4:28 PM Subject: Re: Access SQL - Strip Spaces? > No luck. This is for a SELECT statement. The following threw an > undefined function error. The DB is Access 2000. > > SELECT name, phone, city, > Replace(shortname, " ", "") AS sname > FROM areas > WHERE areacode = '#areacode#' > > Microsoft][ODBC Microsoft Access Driver] Undefined function 'Replace' in > expression > > > ----- Original Message ----- > From: "Dawson, Michael" <[EMAIL PROTECTED]> > To: "CF-Talk" <cf-talk@houseoffusion.com> > Sent: Monday, January 03, 2005 2:53 PM > Subject: RE: Access SQL - Strip Spaces? > > >> 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 Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189195 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