patternMinor

Should SQL full text search match the value test2 when searching for test?

Submitted by: @import:stackexchange-dba·Mar 10, 2026·

Viewed 0 times

fullthesearchingsearchsqltextmatchvaluefortest

Problem

if i have table data that is indexed using full text search in Microsoft SQL server 2005 that includes raw table data such as "test2" should a query using FTS find a match if the search string is "test"?

Solution

Yes you can use full text search in this case.

Select * from your_table WHERE CONTAINS(your_column, '"test*"' );

will find test2.

See section

C. Using CONTAINS with prefix_term in msdn

Code Snippets

Select * from your_table WHERE CONTAINS(your_column, '"test*"' );

Context

StackExchange Database Administrators Q#2720, answer score: 2

Revisions (0)

No revisions yet.