How do you specify more than one COLLATE sequence in an SQL statement? For instance, how do I specify NOCASE & RTRIM in the following? ``` SELECT * from myTable where name = 'ajay' COLLATE ? ```
How do you specify more than one COLLATE sequence in an SQL statement? For instance, how do I specify NOCASE & RTRIM in the following? ``` SELECT * from myTable where name = 'ajay' COLLATE ? ```