M$ SQL Server - Performing case INSENSITIVE query

Microsoft SQL Server 2016 is very limited in functionality, so to perform case-sensitive queries, first, you might need to COLLATE column to SQL_Latin1_General_Cp1_CS_AS.

SELECT id, data
FROM forms
WHERE PATINDEX('%{"name":"SomeName","label":"SomeLabel","type":"text","fieldPreferences":{},"value":"[A-Z]%', data COLLATE SQL_Latin1_General_Cp1_CS_AS) > 0

Tweet