Can anyone see a reason why this won't find all the name matches while taking into account middle initials being entered with the first name (separated by a space)? Thx! (trim(Total_Employee_List.ISP_User_First_Name)+trim(Total_Employee_List.ISP_User_Last_Name)=trim(Valid_Employees.First_Name)+trim(Valid_Employees.Last_Name)) OR (trim(Total_Employee_List.ISP_User_First_Name)+' %'+trim(Total_Employee_List.ISP_User_Last_Name)=trim(Valid_Employees.First_Name)+trim(Valid_Employees.Last_Name)) OR (trim(Total_Employee_List.ISP_User_First_Name)+trim(Total_Employee_List.ISP_User_Last_Name)=trim(Valid_Employees.First_Name)+' %'+trim(Valid_Employees.Last_Name))
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=6 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=6 Get the mailserver that powers this list at http://www.coolfusion.com
