score:0
Accepted answer
Numbers are actually stored in the FTI with an nn prefix, which explains why a search for nn11 returns the same result as for 11 but not n11. It seems there's no direct fix for this, but a workaround is described at http://social.msdn.microsoft.com/Forums/en-US/sqlsearch/thread/8592ea09-fcfb-4fec-a3a4-5e03dedcee3a/
More questions
- Full Text Not Returning The Expected Results
- SQL Server Contains Full Text Function Not Returning Expected Results
- SQL Server Full Text Search not returning expected results
- Clarification as to why EXECUTE AS USER/LOGIN is not returning the expected results?
- EXCEPT SQL statement in SQL Server not returning expected results
- SQL Server full text search contains not working as expected
- Is SQL Server's Full Text Search the right tool for searching phrases, not documents?
- SQL query design not returning expected results
- PHP SQL server 2008 not returning expected results
- T-SQL like not working like expected - returning LESS hits than the same query using =
- Inner Join returning redundant data and not the expected data
- Full text search query not returning result in SQL Server
- Search function stored procedure with multiple fields not returning expected results
- @@DATEFIRST not returning results as described in the docs
- Fulltext search not returning expected results
- Left join will not produce the expected results
- MS SQL : Full Text Search Results are not relevant
- Full Join on two temporary tables not returning all results SQL Server
- Search a database for text and int is returning error The multi-part identifier ... could not be bound
- SQL Server FOR XML query not returning results in expected hierarchy
- ASP.NET SQL query not returning expected results
- Comparing two tables in two different, but structurally identical databases is not returning expected results
- SQL Server Express 2008 R2 - Square brackets in text field not returning results
- Right join returning results not in the where set
- How do I view the full content of a text or varchar(MAX) column in SQL Server 2008 Management Studio?
- EF: The text data type cannot be selected as DISTINCT because it is not comparable
- Why doesn't SQL Full Text Indexing return results for words containing #?
- The data type text cannot be used as an operand to the UNION, INTERSECT or EXCEPT operators because it is not comparable
- Full text search does not work if stop word is included even though stop word list is empty
- SQL Server Full Text Search - Is it possible to search in the middle of a word?
More questions with similar tag
- How to Identify a new value
- SQL query row_number() over partition by query result return wrong for some case
- How do I use column values as xml element names using for xml in SQL Server 2005?
- why execution strategy 'SqlServerRetryingExecutionStrategy' does not support user initiated transactions?
- Left/outer join with linq on c# with where condition clause
- Not able to view constraints & Indexes of External data source objects
- Putting mutliple fields into a Field Name with SQL for XML
- SQL - Potential 100K records out of 2M . Best method to design database
- CTE (Common Table Expression) in EFCore
- What is a "schema provider" in an RDBMS?
- Best practice for changing SQL Server compatibility level from 120 to 140
- Dynamically update display order using coldfusion
- What is the best way of writing a CASE within a CASE for multiple conditions in SQL
- Special characters (subscripts) not shown proprely
- How to convert Visual Foxpro database into SQL Server database
- Divide by zero error encountered - SQL Server
- How to run SSIS jobs sequentially with SQL Agent
- Cannot open database "" requested by the login. The login failed. Login failed for user 'sa'
- Many FIELDTERMINATORs or first two characters?
- How to insert square root symbol or unicode characters into SQL Server database
- Get Identity of destination table when using **DELETE FROM ... OUTPUT ... INTO**
- Select similar rows from a table given a table of IDs
- How to combine multiple XPath queries into one
- Stored Procedure WHERE LIKE ID or NAME
- Counting the articles which don't have a price change in SQL Server
- date ranges in where clause of index view
- Number of Columns Each procedures returns T-Sql
- How to fix identifier must be declared in a stored procedure?
- How to display phone numbers in SQL that contain two and only two '0s'?
- How to get the list of tables and their columns in a database which are having a specific keyword in their name
Source:
stackoverflow.com