> I have tried multiple combinations using the trim function, but > none of them work.
It looks like you're putting the trim() on the value attribute of the input field. How about the value you pass into the query? This should work: select fields from table where somefield = '#trim(form.field)#' You want to trip spaces on your search query in addition to trimming when you re-display the form. -Justin ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330109 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
