how do i do an ORDER BY with caseinsensitivity?

This is a multi-part message in MIME format. --------------424E7A852429B064484F6450 Content-Type: text/plain; charset=us-ascii Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Content-Transfer-Encoding: 7bit i am running livewire with imfx-online and need to do an ORDER by with case insensitivity i have the following select statement: c= database.cursor("SELECT * from brugerprofil where " + "bruger_id like \\"" + astring + "%\\" OR " + "bruger_id like \\"" + astring.toLowerCase() + "%\\" OR " + "bruger_navn like \\"" + astring + "%\\" OR " + "bruger_navn like \\"" + astring.toLowerCase() + "%\\"" + " ORDER BY bruger_id", false); now i need all the rows from the table and i need them with the original case, but i need the ORDER BY to ignore the case.... any suggestions? --------------424E7A852429B064484F6450 Content-Type: text/x-vcard; charset=us-ascii; name="vcard.vcf" Content-Transfer-Encoding: 7bit Content-Description: Card for Martin B. Jespersen Content-Disposition: attachment; filename="vcard.vcf" begin: vcard fn: Martin B. Jespersen n: Jespersen;Martin B. org: TeleDanmark Internet A/S Projektafdeling 'st adr: Symbion;;Fruebjergvej 3;Copenhagen;;2100 KBH ';Denmark email;internet: mbj@dk.net title: Systemkonsulent tel;work: 39177014 tel;home: 32959026 x-mozilla-cpt: ;0 x-mozilla-html: TRUE end: vcard --------------424E7A852429B064484F6450--