Re: Case insensitive queries
From: David Rackley <drack_at_sbctri.sbc.com>
Date: 1996/03/21
Message-ID: <9bybou5zbl.fsf_at_diablo.tri.sbc.com>#1/1
Date: 1996/03/21
Message-ID: <9bybou5zbl.fsf_at_diablo.tri.sbc.com>#1/1
[stuff deleted]
I use the upper() function for comparisons and ordering, eg.
select col1 from table1
order by upper(col1);
Hope this helps.
..dave
-- +----------------------+----------------------------------------------+Received on Thu Mar 21 1996 - 00:00:00 CET
| David Rackley | email: drack_at_tri.sbc.com |
| Southwestern Bell | tel: (512) 372-5516 FAX: (512) 372-5591 |
| Technology Resources | http://www.tri.sbc.com/ |
| 9505 Arboretum Blvd +----------------------------------------------+
| Austin, TX 78759 | It's OK to be a martyr, as long as you don't |
| | bring your own firewood. -- Dr. Jim Rigby |
+----------------------+----------------------------------------------+