Board index » delphi » Case sensitive select query

Case sensitive select query

Hi All!
Does anyone know anything about case-sensitivety in Local SQL ? I need
it badly!....
but cant find anywhere information about it...:(
the problem is:
I have data with names of employees but some names in upper case and
some in lower...:(
so how can i make my select query and get all records?
Thanks in advance.

 

Re:Case sensitive select query


Quote
>I have data with names of employees but some names in upper case and
>some in lower...:(
>so how can i make my select query and get all records?

from your.db D
where upper(D.Name) = "JONES"

Brian
--
Brian Bushay (TeamB)
Bbus...@DataGuidance.com

Re:Case sensitive select query


Use WHERE (UPPER <FIELDNAME>)= <your compare string in Upper
case>

Nick Spurrier (MoDESoft, UK)

Other Threads