Recent content by PamelaLynn

  1. P

    contains syntax

    In SQL Server Full-Text Search, use the `NEAR` operator with the `~` symbol and a number to specify proximity. For your query, try: `CONTAINS(Result, 'BSA NEAR("5") "%"')`. No need to escape the "%" sign. This should search for the desired proximity.
Back
Top Bottom