CHARINDEX case sensitive

https://www.sqlservercentral.com/forums/topic/charindex-is-not-case-sensitive

SELECT CHARINDEX('x', 'X')  这个不区分大小写

 

下面这个会区分大小写

SELECT CHARINDEX('x' collate SQL_Latin1_General_CP1_CS_AS, 'X' collate SQL_Latin1_General_CP1_CS_AS)