I currently am looking for a solution to solve a 'keyword search' problem. I am using the 'like' functionality to retrieve the values that match the keyword that is entered. However, how can I make the search a multiple keyword search using semicolons to seperate the words?? For example: The user should be able to enter 'admin; manager; director;'.
Any input would be greatly appreciated. Thanks
Here is my stored procedure:
create procedure procSearch
@TrainingCertif ication varchar(50) = null
as
begin
select *
from TrainingCertifi cations
where TrainingCertifi cationsType LIKE '%' + @TrainingCertif ication + '%'
end;
Any input would be greatly appreciated. Thanks
Here is my stored procedure:
create procedure procSearch
@TrainingCertif ication varchar(50) = null
as
begin
select *
from TrainingCertifi cations
where TrainingCertifi cationsType LIKE '%' + @TrainingCertif ication + '%'
end;
Comment