.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Full Test Search with single quotes and wild-cards

Posted By:      Posted Date: October 21, 2010    Points: 0   Category :Sql Server


I am trying to find any name that matches O'Bri* with the following query.


declare @Name varchar(50)

set @Name = '"O'Bri*"'


FROM Persons

WHERE CONTAINS(Persons.*, @Name )


returns 0 results.


If I change name assignment to

set @Name = '"O'Brien"'

I get matches.


Can someone point out what i am missing?




View Complete Post

More Related Resource Links

how To Insert the single quotes in sqlcommand in asp.net


Hi all

    i am developed on simple user registeration application in that i gave  address field .when i am trying to enter something like this (1st main,b'lore) but wont take while inserting.

my query is

sqlcommand cmd=new sqlcommand("insert into registeration_form(name,address)values('"+txtname.text+"','"+txt_address+"')",con);

how can i pass the  quotes also to my query please if any one know reply me.


G Dinakaran

Full text search in a Word document



  I´m currently programming a web search application in ASP.Net and having problem with full text searching. My requirements are:

1. Save a byte array from SQL server to word document as a temp file in a server side?

2. How to highlight the string I am currently searching in the Word document and return to the user the sentence with the highlighted string (like on Bing or any other search engines)? Is it possible to fullfill this requirement with full-text search integrated in SQL Server 2008?

Thanks in advance,




full-text search error


I have created procedure for full-text search and it works in SQL Management Studio 2008 (SQL Server 2008 Express) but in Visual Studio 2010 not - I have error:

Full-Text Search is not installed, or a full-text component cannot be loaded.

I have read somewhere that only admin can use full-text indexes - so how I can use full-text search in VS2010 ?

Search for a single site

I have a MOSS farm with multiple sites. I have SharedServices set up, and a separate Content Source for my sites. However, I can't find how to restrict my intranet site to read from the intranet Content Source. It's pulling records from all the sites on the server. Also, is there a way to limit the returned data to certain types, eg: .doc, .xls, Announcement list items? Guidance appreciated.

Full Text Search Return no Result while "Like" does

Someone pls look at the picture and help me I tried Restart the serviceI tried restart the server But the number of row affected is still zero :(

Full Text Search architecture needs to be enhanced for true multilingual web applications

This is for the MS SQL Server development team that handles the code for Full Text Search. Hopefully you will read this. I developed a web application that supports multilingual content. As is typical in the real world, many people often need to create their content in multiple languages or even have multiple languages present within the same content. In my SQL Server database I have a single table that is used to store all the text from all languages. A single column is used to store this text. A separate column is used to identify the language of the content and uses Culture Codes like en-us, de-de, etc.. Furthermore, the format of the content could be plain text, html or whatever. Business logic at a higher level in my application code knows what the format is for each record because data is retrieved within the context of whatever a web page uses. For example, a user sending an e-mail would use plain text for the subject. For the body, html would be used. When these two pieces of information are stored in the same table, my code knows upon retrieving it what is text and what is html. It makes no sense storing a subject and body of an email in two separate tables. This is just a simple example but hopefully you get the point. After going through the documentation on FTS, it became clear to me that my table design is completely incompatible with the FTS paradigm. FTS requ

Full Farm Backup Fails on Windows Sharepoint Services Search Database

I am just now starting to us central administration to backup the entire sharepoint farm.  All content backups fine except for the Search Database.  In looking through the backup log, it appears that the search database may not exist.  How can I determine if the search database actually does exist and if it does not can it be recreated?

To Search a word in all the columns of a Single Table

Dear Friends, How can I search a word in all the columns of a table?Please advise.

switch off full text search in sharepoint 2010

Hi I need to switch off full text search in sharepoint 2010 so that the search only searches on title filename and metadata. How can I do this? Juran

Can i use Windows desktop search indexing service to index a full sql database ?



i wonder if i can use the windows indexing service to perform indexing on a database instead of file system ?

i.e we need to use the windows indexing service to create index table that contains information from all rows in the database



Wild card search with sharepoint datas on SSRS


Hi all,

I have created a report with all the fields from a share-point list. The report is fine. Now I have to do a wild-card search in that.

I have to create a text-box where a user enters any text, and when he clicks "view report" the report table should display all the rows with all the occurrence of that keyword entered on that textbox.


Dataset I used is

<Query>   <SoapAction>http://schemas.microsoft.com/sharepoint/soap/GetListItems</SoapAction>
   <Method Namespace="http://schemas.microsoft.com/sharepoint/soap/" Name="GetListItems">
         <Parameter Name="listName">
   <ElementPath IgnoreNamespaces="True">*</ElementPath>

How to achieve this. Any suggestions

Wild card search with sharepoint datas on SSRS 2008


Hi all,

I have created a report with all the fields from a share-point list. The report is fine. Now I have to do a wild-card search in that.

The report will be like this

No      Name     Department


1       John         Finance

2       David       IT

3       Thomas    Consulting

4       Smith       Legal

I have to create a text-box where a user enters any text, and when he clicks "view report" the report table should display all the rows with all the occurrence of that keyword entered on that textbox.

For eg. if I type 'a' in the text-box, it should display all the rows that has 'a'. The output would be

No      Name     Department


1       John         Fina nce

2       Da vid       IT

3       Thom

Full text search not working for pre-existing data on table after installing docx filter.However wor


Hello All,


I have a strange issue. I have pre-existing data in my table with full text index defined along with catalog. I noticed that I did not have the docx filter ,so I installed the filter and performed the steps below. After installing the filter  I added a couple of new records. I noticed that the full text search pulled up the new records matching the criteria but did not return any pre-existing records. Could you please let me know the issue.Please note – currently I am using sql 2008 , but also would like to verify the same in sql 2005 as well.

Also could you please verify the steps below for installation in sql 2008 and sql 2005 and with different architectures (Eg windows 2003/2008, 32bit, 64 bit etc)


This was tested on VM image on 64 bit architecture Windows 200

autocomplete extender with wild cards


hey all

I just started using the ajax control toolkit and i'm trying to use the autocomplete extender with wild cards.

i tried several things but with no luck.

any ideas? 

full-text search in SQl 2005 and 2008


Considering that full text search engine is now integrated into SQL in 2008 version comparing to 2005, has anybody notice any difference in full text search speed after migrating from 2005 to 2008 using the same type of hardware?



Can't full text search pdf files


I have a MyDocuments table that has the following columns: ID, Document varchar(max), and DocumentType

I'm only able to get HTML and TXT results from my full text search queries -- but I know that I should be getting PDFs as well.

What am I doing wrong?

FYI: I did install the iFilter.

Full Text Search .


Hi ,

I have around 250 tables and i beleive for each table the full text index/catlog) has to be created. When i write a full text search query say for all the tables what would be the cost(Performance) ???? and i also wanted to know about the performance of these full text Queries in an OLTP database(Transactions mainly)

Regards, Santhosh Hiriyanna
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend