I tried this and got this error: Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Undefined function 'Replace' in expression.
I just have a list of states. Not all will have "A" in them, though. Is that my problem? cfquery name="getStates" datasource="tysql" > SELECT Replace(cust_state,"A","") AS custstate FROM Customers ORDER BY cust_state </cfquery> On Thu, Jun 10, 2010 at 4:12 PM, Jamie Robichaud <[email protected]>wrote: > > >Do the replace in your query. select replace(fieldname, > >stringtoreplace, "") as displayname > > > >On Thu, Jun 10, 2010 at 11:42 AM, Jamie Robichaud <[email protected]> > wrote: > >> > > Thanks! Never thought about doing it before the select. Works perfect. > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:5014 Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-newbie/unsubscribe.cfm
