Hi all.
Does anyone know if it´s possbile to do a select command to distinguish between lower case and upper case using SWQL language?
I know that using SQL it´s possible using the expression COLLATE to make the search case sensitive, just like shown in the code below:
<span class="kwd" style="color:#00008b;"> SELECT</span><span class="pln" style="color:black;"> </span><span class="lit" style="color:maroon;">1</span><span class="pln" style="color:black;"><br /></span><span class="kwd" style="color:#00008b;"> FROM</span><span class="pln" style="color:black;"> dbo</span><span class="pun" style="color:black;">.</span><span class="pln" style="color:black;">Customers<br /></span><span class="kwd" style="color:#00008b;"> WHERE</span><span class="pln" style="color:black;"> CustID </span><span class="pun" style="color:black;">=</span><span class="pln" style="color:black;"> </span><span class="pun" style="color:black;">@</span><span class="pln" style="color:black;">CustID </span><span class="kwd" style="color:#00008b;">COLLATE</span><span class="pln" style="color:black;"> SQL_Latin1_General_CP1_CS_AS</span>
If anyonde can help me i would be very grateful.
Cheers,
Valter
