patternsqlMinor
Wildcards in SQL Server full text search
Viewed 0 times
fullsearchsqlwildcardstextserver
Problem
While figuring out with full-text search I've found an article:
FTS differentiates between a symbol defined as a wildcard and the
other symbols. Here are a few symbols used in FTS as wildcards:
```
+==================================+========+==============================================================================================================================================================================================================+
| Expression | Syntax | Description |
+==================================+========+==============================================================================================================================================================================================================+
| Any Character | . | Matches any single character except a line break. |
+----------------------------------+--------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Zero or more | * | Matches zero or more occurrences of the preceding expression, making all possible matches. |
+----------------------------------+--------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| One or more
FTS differentiates between a symbol defined as a wildcard and the
other symbols. Here are a few symbols used in FTS as wildcards:
```
+==================================+========+==============================================================================================================================================================================================================+
| Expression | Syntax | Description |
+==================================+========+==============================================================================================================================================================================================================+
| Any Character | . | Matches any single character except a line break. |
+----------------------------------+--------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Zero or more | * | Matches zero or more occurrences of the preceding expression, making all possible matches. |
+----------------------------------+--------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| One or more
Solution
I doubt that all these symbols are supported.
The list of symbols is probably taken from here. But this documents SQL Server Mamagement Studio (SSMS) functionality.
The only Symbol which is supported is a asterisk (*) at the end of a word. See the documentation here, search for `` on this page.
The list of symbols is probably taken from here. But this documents SQL Server Mamagement Studio (SSMS) functionality.
The only Symbol which is supported is a asterisk (*) at the end of a word. See the documentation here, search for `` on this page.
Context
StackExchange Database Administrators Q#205930, answer score: 4
Revisions (0)
No revisions yet.