alter PROCEDURE usp_Search_BrokerEmployee_sel
@Forename varchar(50),
@Surname varchar(50)
AS
-- ** Used within frm_SearchBrokerEmployee **
SELECT  Broker_Employee.fs_forename, 
 	Broker_Employee.fs_surname, 
     	Brokers_in_UID.fs_brokerNameinUID, 
 	Broker_Employees_in_UID.fs_UID, 
     	Broker_Employee_Positions.fs_positionDescription, 
     	Broker_Employees_in_UID.f_brokerEmployeeCode, 
     	Broker_Employees_in_UID.fl_brokerCode,
	Broker_Employees_in_UID.fb_Validated
FROM 
 	Brokers_in_UID 
INNER JOIN
 	Broker_Employees_in_UID 
ON 
 	Brokers_in_UID.fl_brokerCode = Broker_Employees_in_UID.fl_brokerCode
AND
 	Brokers_in_UID.fs_UID = Broker_Employees_in_UID.fs_UID
INNER JOIN
     	Broker_Employee
ON 
 	Broker_Employees_in_UID.f_brokerEmployeeCode = Broker_Employee.fa_brokerEmployeeCode 
INNER JOIN
 	Broker_Employee_Positions
ON 
 	Broker_Employees_in_UID.fl_position = Broker_Employee_Positions.fa_positionCode
WHERE 
 	Broker_Employee.fs_Forename like (@Forename + '%')
AND
 	Broker_Employee.fs_Surname like (replace(@Surname,'e','[e,é]') + '%')
ORDER BY 
 	Broker_Employee.fs_surname, 
 	Brokers_in_UID.fs_brokerNameinUID, 
 	Broker_Employees_in_UID.fs_UID

declare @b table (name varchar(50) collate SQL_Latin1_General_CP850_CI_AI)
insert into @b
select 'äöë' union all
select 'aoe'

select * from @b
where name like '%aoe%'

quote:

---

What version of SQL Server are you using? Only SQL Server 2000 allows collations to be set at the server, database or column level. Before SQL Server 2000, you could only specify the collation on the server level.

Tara

---