Case insensitive queries in D3

Shane Mulo

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Case insensitive queries in D3

After moving a D1 application to D3, I discovered that my paramaterised SQL
queries are now CASE SENSITIVE, meaning that unless users exactly match the
case of the underlying database fields, no match occurs.

Can anyone recommend a solution to this problem?

Thanks

Shane M
Mu...@dpi.qld.gov.au

Peter Ingh

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Re:Case insensitive queries in D3

Quote

"Shane Mulo" <Mu...@dpi.qld.gov.au> wrote:
>After moving a D1 application to D3, I discovered that my paramaterised SQL
>queries are now CASE SENSITIVE, meaning that unless users exactly match the
>case of the underlying database fields, no match occurs.

>Can anyone recommend a solution to this problem?

Select * from MyTable where :MyParam = UPPER(DataField)

Make the value for MyParam uppercase before storing it.

Quote

>Thanks

>Shane M
>Mu...@dpi.qld.gov.au

Peter S Ingham p...@actrix.gen.nz
Lower Hutt, New Zealand

Other Threads

1. How to make InterBAse query case insensitive?

2. How to perform a case-insensitive query?

3. How to make SQL query case insensitive?

4. Case insensitive SQL query

5. Case-insensitive queries

6. case insensitive query

7. Case-Insensitive query

8. Case-Insensitive Queries on a Memo Field

9. Case Insensitive Query on Interbase Table?

10. case INsensitive query