Board index » delphi » Case sensitive select query

TomCat

Delphi Developer

Thu, 08 Jun 2000 03:00:00 GMT

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.

Brian Bushay Tea

Delphi Developer

Fri, 09 Jun 2000 03:00:00 GMT

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

Nick Spurri

Delphi Developer

Fri, 09 Jun 2000 03:00:00 GMT

Re:Case sensitive select query

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

Nick Spurrier (MoDESoft, UK)

Other Threads

1. SQL Select - Case Sensitive pattern matching..

2. Oracle 8i case sensitive queries

3. accent and case sensitive query problem

4. Case sensitive problem of Paradox query engine

5. Case Sensitive vs Case-InSensitive

6. Help: FindFirst, Case-sensitive?

7. Like statement case sensitive on Memo field

8. D1: DBF & Non-Case Sensitive Indicies

9. Case Sensitive in Foxpro/Delphi

10. DB Text search case-sensitive?