Conaway, Amy C wrote: > > SELECT Vendor_Circuit_Number, Total_Employee_List.ISP_User_Last_Name, > Total_Employee_List.ISP_User_First_Name, Valid_Employees.Last_Name, > Valid_Employees.First_Name FROM Total_Employee_List INNER JOIN Valid_Employees ON > (Total_Employee_List.ISP_Employee_Badge_Number=Valid_Employees.[Badge Number]) > 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)+" %") LIKE > trim(Valid_Employees.First_Name) AND
Does LIKE work in both directions in your database? Shouldn't it be "<field> LIKE <pattern>", instead of "<pattern> LIKE <field>"? Jochem PS Indenting, table aliassing and limiting lines to < 80 characters helps for readability, which in turn helps in getting a timely response. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
