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