Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Search in a table

Author  Topic 

sri130785
Starting Member

2 Posts

Posted - 2009-03-22 : 10:09:56
Hi friends, How r u , i m new to this forums. Please help by the bellow doubt
I am using asp.net C# and SQL server , my doubt is i have to pass one string ( Group of words separated with commas(,)) so i need to search every word in my particular table(particular column only) and send those records to my front end
let us take example , i have Skill Text box ,Contain (.net,java,html)
in my table skills columns is there so i need to search for every word in my table ...

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2009-03-22 : 13:10:33
Consider using SQL's full text search. Have a good read through books online to get started.

--
Gail Shaw
SQL Server MVP
Go to Top of Page
   

- Advertisement -