I have a last name and first name field in my table but want to be able to submit a form with someone either entering a first name or last name or both last name and first name.
My code is below but it's not quite working how I need it yet.
<cfquery name="qSearch" datasource="#request.dsn#" username="#request.dsnUsername#" password="#request.dsnPassword#">
FROM site_users t1
WHERE last_name +' '+ first_name = '%#FORM.field_search#%'