When querying exact SQL phrases that include symbols, you need to add your own logic with SQL Server's full-text search feature, as it does not index non-letters. Options include incorporating a WHERE clause with LIKE to contain your symbol and also using a CASE in the SELECT list to rank the symbol and non-symbol results. In this tip, SQL Server expert Michelle Gutzait shares steps to successfully search for exact phrases that contain symbols.
Source Click Here.
Post a Comment