Has anybody tried these solutions and measured the performance with VarChar(max) and indeed NVarChars of any length as my databases are all Unicode?

The examples shown all use simple comparisons. I implemented a more complex requirement, which is not that uncommon, to match a date in a date range.

The situation is that a...