Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature may not be available in some browsers.
PRINT PATINDEX('%[a-z]%', 'Aa')
PRINT PATINDEX('%[a-z]%' COLLATE SQL_Latin1_General_CP1_CS_AS, 'Aa' COLLATE SQL_Latin1_General_CP1_CS_AS)
PRINT PATINDEX('%[A-Z]%' COLLATE SQL_Latin1_General_CP1_CS_AS, 'aA' COLLATE SQL_Latin1_General_CP1_CS_AS)
PRINT PATINDEX('%[a-z]%', 'Aa')
PRINT PATINDEX('%[a-z]%' COLLATE Latin1_General_BIN, 'Aa' COLLATE Latin1_General_BIN)
PRINT PATINDEX('%[A-Z]%' COLLATE Latin1_General_BIN, 'aA' COLLATE Latin1_General_BIN)
PRINT PATINDEX('%[a-z]%', 'Aa')
PRINT PATINDEX('%[a-z]%' COLLATE Latin1_General_CS_AS_KS_WS, 'Aa' COLLATE Latin1_General_CS_AS_KS_WS)
PRINT PATINDEX('%[A-Z]%' COLLATE Latin1_General_CS_AS_KS_WS, 'aA' COLLATE Latin1_General_CS_AS_KS_WS)