SQL SERVER 'Contains' didn't return the actual result - by Riyas V K

Status : 

  Won't Fix<br /><br />
		Due to several factors the product team decided to focus its efforts on other items.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.


1
0
Sign in
to vote
ID 804524 Comments
Status Closed Workarounds
Type Bug Repros 0
Opened 10/3/2013 11:50:35 PM
Access Restriction Public

Description

I have a problem with sql server contain clause.I want to search the table contents with search word starting with '.' using conatins clause .

If i search with the pattern '.n', it returns all the filecontent starting with 'n' ,but this query didn't check for the pattern '.n'

SELECT    resumetb.ResumeCode
		, resumetb.ResumeOwnerName
		, resumetb.FileLocation
		, resumetb.UploadDate
		, resumetb.UserCode
FROM  tbResumeDetails AS resumetb 
WHERE contains (resumetb.FileContent,'".n*"')

If i search with the pattern '.net', the query returns the correct result.
SELECT    resumetb.ResumeCode
		, resumetb.ResumeOwnerName
		, resumetb.FileLocation
		, resumetb.UploadDate
		, resumetb.UserCode
FROM  tbResumeDetails AS resumetb 
WHERE contains (resumetb.FileContent,'".net*"')
Sign in to post a comment.
Posted by Microsoft on 11/1/2013 at 12:01 PM
Thank you for submitting this feedback. We are investigating the issue and will update you when we have more information.