SQL - case sensitive searching - HOW TO TURN IT OFF?

Jonathan Gill

Delphi Developer

Thu, 20 Nov 2003 01:17:28 GMT

SQL - case sensitive searching - HOW TO TURN IT OFF?

Hi,

I've just written my first application using BDE and have written a nice
wildcard search routine that works fine. However, is it possible to perform
NON-case sensitive searches, and also does anyone know how to search across
all fields in a database for the same information instead of searching only
one field?

Any help will be greatly appreciated

regards

Jon

Jonathan Gil

Delphi Developer

Thu, 20 Nov 2003 16:00:34 GMT

Re:SQL - case sensitive searching - HOW TO TURN IT OFF?

Just to let you all know I worked it out anyway, so no need for any help

thanks

Jon

Quote

Jonathan Gill <j...@cdman.force9.net> wrote in message

news:9fb739$pl8$1@neptunium.btinternet.com...

Quote

> Hi,

> I've just written my first application using BDE and have written a nice
> wildcard search routine that works fine. However, is it possible to
perform
> NON-case sensitive searches, and also does anyone know how to search
across
> all fields in a database for the same information instead of searching
only
> one field?

> Any help will be greatly appreciated

> regards

> Jon

Other Threads

1. not case sensitive Searching using SQL LIKE operator in memo fields

2. search case not sensitive with SQL

3. turning off case sensitivity

4. DB Text search case-sensitive?

5. Search String (Case Sensitive)

6. case sensitive search

7. case sensitive search, collation drivers problem

8. Case Sensitive vs Case-InSensitive

9. SQL case sensitive

10. Local SQL case sensitive LIKE operation?!