Kev D

Kev D

  • NA
  • 4
  • 0

delimitered list through sql server

Jul 22 2008 10:33 AM
Hello

I have a table in SQL server which looks like this:

service_id
service_name
service_keywords

The data in service_keywords is delimitered with a colon eg. website,stuff,testing,words

Now I have a webform which allows people to search (via a textbox). When they enter a word it should check all the words in the service_keywords columns and return the id's that have a match (same method as LIKE in sql statements, eg site should also match the keyword website).

Can I do this in .NET or do I have to do this via a stored procedure or is there any other option available? Can't seem to figure this out.

Thanks in advance.