Microsoft
70-432 · Question #86
You are a database developer for your company. You are writing a query that will search a resume text column for specified skills. The results must include both synonyms and exact matches. You need…
The correct answer is C. CONTAINS. See the full explanation below for the reasoning.
Question
You are a database developer for your company. You are writing a query that will search a resume text column for specified skills. The results must include both synonyms and exact matches. You need to write the query to fulfill the requirements. Which Transact-SQL function should you use?
Options
- ASOUNDEX
- BCHARINDEX
- CCONTAINS
- DPATINDEX
How the community answered
(30 responses)- A3% (1)
- B10% (3)
- C83% (25)
- D3% (1)
Community Discussion
No community discussion yet for this question.