Hi,

Although this not DNN related maybe a SQL whiz kid could answer this quickly for me.

I'm have a brain block with an approach to the following and I'm trying to use a stored procedure and not dynamic concatinated queries.

I have a list of "Teachers" (tblTeachers) who can speak a set of languages (tblLanguages).

A teacher can speak English only, English and French and so on.

In editing the teachers profile I display the languages in a checkbox list and save the selected items to a 3rd table (tblSelectedLanguages which has two fields, TeacherId and LanguageId).

Alright so far.

Now I want to do a search.  For example I want to search for a teacher that speaks both French and Spanish.

On the search form I use a checkbox list to display the list of languages.  Based on the selected checboxes I pass a Comma Delimited String as a parameter to a stored procedure.

Heres where I need help, can't get my head around the syntax.

How do I return a list of teachers based on the Comma Delimited String?

Thanks for any help.