The % as a wildcard only works with a LIKE comparison, not an equality (=)
comparison. Try this and see if you at least get closer:
(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(Valid_Employees.First_Name) + trim(Valid_Employees.Last_Name) LIKE
trim(Total_Employee_List.ISP_User_First_Name) + '%' +
trim(Total_Employee_List.ISP_User_Last_Name))
OR
(trim(Total_Employee_List.ISP_User_First_Name) +
trim(Total_Employee_List.ISP_User_Last_Name) LIKE
trim(Valid_Employees.First_Name) + '%' + trim(Valid_Employees.Last_Name))
"Conaway, Amy C" <[EMAIL PROTECTED]>
08/13/2003 10:50 AM
Please respond to sql
To: SQL <[EMAIL PROTECTED]>
cc:
Subject: odd problem
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
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
