'SQL Server not applying criteria for first character
I have the following SQL query:
select * from
(select N'🦋Christina 🦋 Taylor' name) a
where name like '[a-z]%'
I am expecting the resultset to be empty because the first character is not an alphabet character. But in fact the query above returns a row.
Why is that?
I am using SQL server 2016.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|
