Board index » delphi » Ordering with Sql Statements NOT Case Sensitive

Nadav Golombick

Delphi Developer
Fri, 22 Mar 2002 03:00:00 GMT

Ordering with Sql Statements NOT Case Sensitive

I have a Tquery where I enter a Sql statement with an order by clause which
operates on a string field. The problem is that the order by statement sorts
case-sensitive. I need to sort the query Case-Insensitive. Can anyone help
me out?

Nadav

 
David Beardwoo

Delphi Developer
Fri, 22 Mar 2002 03:00:00 GMT

Re:Ordering with Sql Statements NOT Case Sensitive


ORDER BY  UPPER( MyStringField )

i have found in the past that using UPPER can slow queries down.  you'll find
out... :)

Quote
Nadav Golombick wrote:
> I have a Tquery where I enter a Sql statement with an order by clause which
> operates on a string field. The problem is that the order by statement sorts
> case-sensitive. I need to sort the query Case-Insensitive. Can anyone help
> me out?

> Nadav

Stewart Hecto

Delphi Developer
Fri, 22 Mar 2002 03:00:00 GMT

Re:Ordering with Sql Statements NOT Case Sensitive


if you use functions in an SQL statement then (at least in Oracle)
the indexes are not used and full table scans are performed.

Quote
David Beardwood wrote:

> ORDER BY  UPPER( MyStringField )

> i have found in the past that using UPPER can slow queries down.  you'll find
> out... :)

> Nadav Golombick wrote:

> > I have a Tquery where I enter a Sql statement with an order by clause which
> > operates on a string field. The problem is that the order by statement sorts
> > case-sensitive. I need to sort the query Case-Insensitive. Can anyone help
> > me out?

> > Nadav

--
Stewart
ICQ: 5308166
http://freespace.{*word*269}.net/s.hector/index.html
David Beardwoo

Delphi Developer
Fri, 22 Mar 2002 03:00:00 GMT

Re:Ordering with Sql Statements NOT Case Sensitive


oh.

i guess that makes sense.  thanks for the tip.
dave

Quote
> if you use functions in an SQL statement then (at least in Oracle)
> the indexes are not used and full table scans are performed.

> > ORDER BY  UPPER( MyStringField )

Stewart Hecto

Delphi Developer
Sat, 23 Mar 2002 03:00:00 GMT

Re:Ordering with Sql Statements NOT Case Sensitive


Ordering CAN be case sensetive, depends on the database - Oracle
orders are case sensitive for example:

anthony
ben
emma
Anthony
Ben
Emma

Quote
David Beardwood wrote:

> oh.

> i guess that makes sense.  thanks for the tip.
> dave

> > if you use functions in an SQL statement then (at least in Oracle)
> > the indexes are not used and full table scans are performed.

> > > ORDER BY  UPPER( MyStringField )

--
Stewart
ICQ: 5308166
http://freespace.{*word*269}.net/s.hector/index.html

Other Threads

1. Case sensitive in SQL Statements??

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

3. search case not sensitive with SQL

4. ORDER BY Case Sensitive

5. Like statement case sensitive on Memo field

6. These two statements appear to be order-sensitive

7. Case statement : How to check on edit.text in case statement

8. Case statement within a case statement

9. TTable.FindNearest - Not Case Sensitive?

10. Case Sensitive vs Case-InSensitive