sql query to search a word
Greetings!

I have two tables in my database say Table1 and Table2.In Table1 i have skillid and skill.
In Table2 id , skill_desc and etc...
In Table2 skill_desc colum contains comma seperated description is added in each as below,
C#,Episerver,Asp.Net.
In tbale1 for example skillid----1 and skill--C#..
My requirement is , how to write an sql query to get the skillid from Table1 if the skill is present in skill_desc column which is a comma seperated string in Table2.
I have done a lot of googling and tried to write differnt queries but didnt able to find a better solution.Please help.
Thanks in Advance
Regards
sql query to search a word
===

Greetings!

I have two tables in my database say Table1 and Table2.In Table1 i have skillid and skill.
In Table2 id , skill_desc and etc...
In Table2 skill_desc colum contains comma seperated description is added in each as below,
C#,Episerver,Asp.Net.
In tbale1 for example skillid----1 and skill--C#..
My requirement is , how to write an sql query to get the skillid from Table1 if the skill is present in skill_desc column which is a comma seperated string in Table2.
I have done a lot of googling and tried to write differnt queries but didnt able to find a better solution.Please help.
Thanks in Advance
Regards