COLLATE Clause Precedence
The COLLATE clause has high precedence (higher than ||), so the following two expressions are equivalent:
COLLATE Clause PrecedenceThe COLLATE clause has high precedence (higher than ||), so the following two expressions are equivalent: