delimitered list through sql server

[Kevin_D]

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.

[Hack]

Welcome to DevX :WAVE:Can I do this in .NET or do I have to do this via a stored procedureEither one actually. Which do you prefer?

If you can go with a stored procedure, that is the route I would take simply because changing the stored procedure would not mean, necessarily, changing any VB.NET code. Changing VB.NET code would require recompiling and redistributing.