.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

Free text search in sqlserver

Posted By:      Posted Date: April 14, 2011    Points: 0   Category :

We are having data in in format like 'Ram_Shyam' and this column is full text search enabled.

Now when we do a search on "Ram_Shyam", it brings us the desired record but when we tried to search 'Ram' or 'Shyam' then records having 'Ram_Shyam' are not being populated.


Please help us in this in regard.

Thanks in advance for helping.

View Complete Post

More Related Resource Links

ASP.net free text search issue for "C#"


In my ASP.net application I have used index server utility to search specific text from word/text files.

For this functionality I have used index server and configured folder. After implementation of this program this was running fine but after some time user reported they can not find keyword "C#" or any word with "#". I think I should share my experience and solution with other developer who may also faced or facing this issue.

Use the following code and it will work.

"Desc" is the text box name and searchstr is the search string paased to index server to search from files.


Desc.Text.contains("C#") Then

searchStr = "C#"


searchStr = Desc.Text.ToLower()


End If

Free Text Search Behaviour


HI all,

  It would be greatly helpfull to explain the below behaviour in SQL Free text. I have column whose datatype is string and search in that column

 value/Data in the column is "solutions property temperature"

and i am searching using following query

SELECT *   FROM PI_GENERAL(NOLOCK) va JOIN CONTAINSTABLE(PI_GENERAL,name,'"solution property*"') t ON va.id = t.[key]

--  it gives the above record.

when i changed the value to "solutios property temperature" (removed the "n").

i am searching using following query

SELECT *   FROM PI_GENERAL(NOLOCK) va JOIN CONTAINSTABLE(PI_GENERAL,name,'"solutio property*"') t ON va.id = t.[key]

i am not getting the result.

Please some one explain the above behavuiour.


Vijay A


Filter search over multiple text columns


Hi everyone,

I'm working on a library that stores information on various cases. The case table has several columns that contain descriptive strings on what happened in the case. I would like to create a single filter that returns all cases where the search string is found in any of the columns. I've looked at Dynamic Data Filtering, but as far as I can tell, the "Contains" filter only allows you to connect to each column individually. Has anyone tried this?



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,




Search does not find text in Word document stored in document library on a Report Center site within



We have a document library on a site created off of the Report Center site template. We uploaded a Word 2007 document with the word zebra in the text. Using the search bar at the top of the page we selected This list: Our document library and searched for zebra. We received no results.

We tested the same thing on another site (site template Team site) within the same site collection and search worked fine.

Does the Report Center search function differently then the search functionality on the Team site?

Tamara Bredemus SharePoint Minion...working up to Maven

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 text handling

Please advise how the search text boldfacing and URL list is constructed in the following example: http://www.asp.net/search?q=MVC Thanks.

Text Search Strategy Question for the SSIS Gurus...

BACKGROUND: As I have mentioned in some of my other posts I am using SSIS 2005 to replace an existing MS Access 2003 / VBA based ETL engine which I developed some years back.   Part of my existing Access-based ETL performs a text search of the source records and I am now attempting to replicate that functionality in SSIS (replicate in terms of the end-result and not necessarily the methods used to get to that end result).  I have an idea of how I plan to go about this but since am relatively new to SSIS so would greatly appreciate the feedback of those more experienced... DETAILED DESCRIPTION: In the source (Sybase ASE15) database, there is an "object" table (not the actual table name but for illustrative purposes it will suffice).  Within the object table there is a "description" column which is a char(60) datatype.  The description column simply represents a description of the object as defined by the source system end-user. For my ETL solution I allow the ETL administrator to define one or many (1...n) key words or phrases which represent search criteria.  These search criteria are stored in a reference table in my target SQL Server 2005 database (the same database to which my ETL will transform results and store them).  My objective, is as follows:  For each of the 1...n search criteria defined, try and find th

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 :(

Accent-insensitive search with Arabic text

I've indexed documents in Arabic that contain accents (or diacritics) and I want to be able to conduct searches where the query does contain the accents but returns results for texts that both contain and do not contain accents. For example, if I have a document that contains the word "????????????" (a word with accents), I would like to be able to search using the word "???????" (the same word without accents). I have tried several combinations of configurations in my environment to no avail. I have tried installing my SQL Server using Arabic collation and I have installed the Arabic language pack on my OS. I have also tested the same thing with French, and it is working properly. The spsearchdiacriticsensitive value is set to false (the default). Does anyone know how to get this working? Is it even possible to do accent-insensitive search with Arabic? More on my environment: MOSS 2007 Enterprise Windows 2008 R2 SQL Server 2008 R2 Thank you

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

Advanced text search...

See requirement examples below.... any suggestions / ideas are helpful.... I am using SQL server 2005 and I have a limitation that I should not use full text search. I have a table with nvarchar(100) column which holds data. Users will enter search terms on text box with predefined grammar. See examples below..... 1. BEFORE operator "intersection before(n) car" finds intersection when it precedes car by n terms, where n is the nearness value 2. NEAR operator "intersection near(n) car" finds intersection within n terms of car, where n is the nearness value  

how to search a text using jquery Ajex

how to search  a text using jquery Ajex

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

Advanced text search...


See requirement examples below.... any suggestions / ideas are helpful....

I am using SQL server 2005 and I have a limitation that I should not use full text search.

I have a table with nvarchar(100) column which holds data. Users will enter search terms on text box with predefined grammar. See examples below.....

1. BEFORE operator

"intersection before(n) car" finds intersection when it precedes car by n terms, where n is the nearness value

2. NEAR operator

"intersection near(n) car" finds intersection within n terms of car, where n is the nearness value


ASP.NET MVC2 Custom routing with wildcard or free text url


I have a requirement to add specific functionality to an asp.net mvc2 web site to provide addtional SEO capability, as follows:

The incoming URL is plain text, perhaps a containing a sentence as follows

"http://somesite.com/welcome-to-our-web-site" or "http://somesite.com/cool things/check-out-this-awesome-video"

In the MVC pipeline, I would like to take this URL, strip off the website name, look up the remaining portion in a database table and call an appropriate controller/view based on the content of the data in the table. All controllers will simply take a single parameter bieng the unique id from the lookup table. A different controller may be used depnding on different urls, but this must be derieved from the database.

If the url cannot be resolved a 404 error needs to be provided, if the url is found but obsolete then a 302 redirect needs to be provided.

Where the url is resolved it must be retained in the browser address bar.

I have had a look at the routing model, and custom routing and can't quite work out how to do it using these, as the controller would not be predefined, based on a simple route. I am also unsure of what to do to provide 404, 302 back to the headers also. Perhpas I need a custom httpmodule or similar but going there went beyond my understanding.

This must be possible someho

Search data from sharepoint list and populate repeating table (Seach text should be entre in first f


Hi All,

I am newbie to infopath.

I have assignment to search data from sharepoint list and display it to repeating table. Below is the case in detail.

i. User enter search text in first textbox of repeating table.

ii. After text enter you will Enter or click tab button.

iii. As user press Tab /Enter, the other textboxes of repeating table will populate with data automatically.

iv. If searched data rows are more then one, then dynamically add new row's in repeating table and  show searched data.

I am working at offical assignment and it's deadline is very tough. i had made extensive search at google and msdn forum but unable to accomplish. I would appreciate and thanks is some provide me solution in form to a small infopath application and code snippet.




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