Appendix B: Microsoft SQL Server Database Special Characters and Reserved Words

The Override Advanced Shopper Search Syntax (SHOP_OVERRIDE_ADV_SEARCH_SYNTAX) parameter on the Application Parameters page, when set to True, is used to define the logic used in the Shopper (SHOP) page for the ‘Search For’ search string. For a SQL Database, upon searching, the system appends double quotes to each end of the SHOP ‘Search For’ text string before submitting the query to the database. For example, if you search for OFFICE SUPPLIES, the system submits that search query as “OFFICE SUPPLIES”.

Source

http://msdn.microsoft.com/en-us/library/ms142571.aspx

 

 

 

Special characters

 

 

"

 

enclosed, to search for specific terms, such that "term1 term2" looks for occurrences this exact sequence of characters; vs. term1 term2 searches for term1 AND term2 within the text

*

 

multiple character wildcard with text enclosed in double quotation marks; "term*" searches for words that begin with the prefix term; "term1 term2*" searches for phrases that begin with the prefix term1 and then begin with the prefix term2

()

 

evaluation grouping

 

 

 

 

 

 

Boolean operators

 

 

 

AND

 

 

OR

 

 

AND NOT

 

~

NEAR

to search for terms in close proximity to each other

 

 

 

 

 

 

 

 

 

Keywords

 

 

 

FORMSOF(INFLECTIONAL, "term")

to search for all the different verb tenses of term or the singular and plural forms of term

 

term WEIGHT(x)

to search for term with a weighting value of x, where x is between 0.0 (low) and 1.0 (high), inclusive, to specify the degree of importance for found instances of term