Respect leading and trailing spaces when querying SQL Server
In my current project, I have to implement a search functionality where users can provide a search term and the search term is to be matched exactly. This also means that any leading and trailing in the search term must be respected. Let’s say we have these Posts in the database And we initialise the … [Read more…]