<div>
i need to write a query to check whether/not the @name has at least one qualication from the list given.<br />

</div>


i need to write a query to check whether/not the @name has at least one qualication from the list given.


<div>
<div class="content wysiwyg-content">
for example<br />
create function find_qualification_exists(<wbr />@name varchar(65))<br />
<br />
the @name is included with qualification. for example : 'Mark Froster MA, CRC,CCM,RN'. <br />
i have the qualifications list. ('abc','xxx','ccm','rn','c<wbr />rc','xyz',<wbr />'lmn','opq<wbr />')<br />
Now i need to write a query to check whether/not the @name has at least one qualication.<br />
<br />
Function should return 'yes' if qualification exists or 'no' if not.
</div>
</div>


for example
create function find_qualification_exists(@name varchar(65))

the @name is included with qualification. for example : 'Mark Froster MA, CRC,CCM,RN'. 
i have the qualifications list. ('abc','xxx','ccm','rn','crc','xyz','lmn','opq')
Now i need to write a query to check whether/not the @name has at least one qualication.

Function should return 'yes' if qualification exists or 'no' if not.

IN sql server 2005 how to write a function to find words in a sentence.

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.