How To Get Specific Result From A Search In A Sql Column Populated With Xml

I have the following XML which is a column (content_html) in a SQL table (ntext type): <

Solution 1:

You should follow the same pattern that you use for <gender>:

content_html LIKE'%<speciality%'+@strService+'%</speciality%'

and

content_html LIKE'%<OfficeLocations>%'+@strLocation+'%</OfficeLocations>%'

etc.