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" <[email protected]>
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 Silver Sponsor - RUWebby
http://www.ruwebby.com
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189193
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
