search based on free text(multiple words entered by user)

[rakeshjena]

Based on the full text entered by user in "search" textbox , i want to search every words that is present in various columns of my tbl_products table. how to achieve this.i prefer to use contains than like.plz help me. Examples are welcomed than links plz help

[Mycroft Holmes]

Contains is a c# or .net concept, for sql you need to use wild cards % in your stored procedure.

Set @SearchText = '%' + @SearchText + '%'
Where Col1 like @SearchText
or Col2 like @SearchText
or Col2 like @SearchText

Never underestimate the power of human stupidity RAH

[Lost User]

rakeshjena wrote:

Examples are welcomed than links

It's not something that can be explained with a copy/paste example. If you want a full-text search, then you have to configure[^] the server.

Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^]