IN sql server 2005 how to write a function to find words in a sentence.
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.