Ask a question

Search Forums:

• Search SharePoint - Search Forum
• Search All SharePoint Products and Technologies Forums
• Search All Microsoft TechNet Forums

 

Enterprise search SQL using Contains on the PreferredName field with wildcard

• Friday, October 30, 2009 2:07 PMPremjitM

   
  

  0

  Sign In to Vote
  I try to search the field using this: "Select PreferredName FROM portal..scope() WHERE \"scope\"='people' AND InternationalGroup <> '' AND ( CONTAINS(PreferredName,'\"da*\"')) ORDER BY PreferredName ASC"
  
  and 0 results are retrieved; even though I know there are peoples names present in the PrefferedName field whose surname or lastnames begin with "da"
  
  If I use this termI get all the retrievals back
  "Select PreferredName FROM portal..scope() WHERE \"scope\"='people' AND InternationalGroup <> '' AND ( CONTAINS(PreferredName,'\"*\"')) ORDER BY PreferredName ASC"
  
  Any advice please
  • Reply
  • Quote