Thanks for the help. I tried this, and it didn't work. Two possible variables are that I am using a copy of ColdFusion on my laptop, connecting to an Access database. Also, I'm running ColdFusion 7. Do you think any of those things might make a difference. I'm able to do the query without the replace function.
What gets me is that ColdFusion is comlaining with: "Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Undefined function 'replace' in expression." Any Thoughts? Thanks Jamie, Lewis On Wed, Jun 16, 2010 at 1:07 PM, Jamie Robichaud <[email protected]>wrote: > > Try: > > Select replace('cust_state','a','') as custstate > > At least for me this format worked. > > >cfquery name="getStates" datasource="tysql" > > >SELECT Replace(cust_state,"A","") AS custstate > >FROM Customers > >ORDER BY cust_state > ></cfquery> > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-newbie/message.cfm/messageid:5016 Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-newbie/unsubscribe.cfm
