Here we will see how to simply make a query in a table without worring about style case.
The solution is the KeyWord COLLATE.
As a matter of fact, if you do a query which returns all elements (by a case-unsensitive way) inside en table with a LIKE clause for example, you’ll have to use COLLATE clause. This clause must be combined with a string expression to apply a collation cast.
Here let’s choose SQL_Latin1_General_Cp437_CI_AI.
Latin1_General: Identifying alphabet or used language for which sort are applied.
Cp437: code page 437.
AI: accent unsensitive.
SELECT * FROM TABLE WHERE My_Field LIKE '%Calculé%' -- means computed in French COLLATE SQL_Latin1_General_Cp437_CI_AI;
Here’s the output :
calcule CalCule calculE Calculé