RE: [SQL] Order by email address by domain ?

edvache [mailto:[EMAIL PROTECTED]] Sent: Friday, May 11, 2001 3:38 AM To: [EMAIL PROTECTED] Subject: [SQL] Order by email address by domain ? Hi, I just want to order by a listing of email address by domain like : [EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL PR

Re: [SQL] Order by email address by domain ?

Why is everyone else suggesting new functions? This works (in 6.5.3): ORDER BY lower(substring(email from position('@' in email)+1 )), lower(email) remove the lower() functions if you don't need them (I had mixed case addresses). I am guessing/assuming that it's cheaper to just use entire e

Re: [SQL] Order by email address

Herve, Etc. Ooops! A couple of misteaks in that last post: > > [EMAIL PROTECTED] > > [EMAIL PROTECTED] > > [EMAIL PROTECTED] > > [EMAIL PROTECTED] > > [EMAIL PROTECTED] > > > > Is it possible and how ? > > Given the relational rule of Atomicity (each discrete piece of > information shall have

Re: [SQL] Order by email address

Herve, > [EMAIL PROTECTED] > [EMAIL PROTECTED] > [EMAIL PROTECTED] > [EMAIL PROTECTED] > [EMAIL PROTECTED] > > Is it possible and how ? Given the relational rule of Atomicity (each discrete piece of information shall have its own column or row), the solution is for you to make "e-mail id" and "

[SQL] Order by email address by domain ?

Hi, I just want to order by a listing of email address by domain like : [EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL PROTECTED] Is it possible and how ? Thanks ! -- Hervé Piedvache Elma Ingenierie Informatique 6, rue du Faubourg Saint-Honoré F-75008 - Paris