Home Dashboard Directory Help
Search

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


Status: 

Active


1
0
Sign in
to vote
Type: Bug
ID: 804524
Opened: 10/3/2013 11:50:35 PM
Access Restriction: Public
0
Workaround(s)
view
0
User(s) can reproduce this bug

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*"')
Details
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.
Sign in to post a workaround.