Hi Ray - I've tried this and modified the query to get just the email field and compare the username to the email field. I don't see why it's not working:
<cfset user = Session.username & "@"> <cfquery name="getUser" datasource="myDSN"> select email from client where email like '#user#%' </cfquery> <cfdump var="#getUser#"> CFDump produces: select email from client where email like ' adgparke @*' Does the space between the username and the "@" make a difference? Does it make a difference that this is an Access database? I don't get why it's not working. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/sql/message.cfm/messageid:3207 Subscription: http://www.houseoffusion.com/groups/sql/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.6
