Would this work for searching something in my DB?

Question

Create Proc CargarAnuncioPorBusqueda
    @searchString varchar(max)
AS 
select * from Anuncio where titulo Like '%'+ @searchString + '%'

Say the user writes: "pools", would this Stored Procedure return everything that has "pools" in the "titulo"?

Thank you. :)

Answer 1

Yes. It would return "spools", "poolside", "pools", etc.

Answer 2

Yes that's the correct use of the like operator.

You can also do a logical Starts With like this:

like @searchterm + '%'

and Ends With like this:

like '%' + @searchterm

Answer 3

It's not a very fast search though.