Re: Non-Case Sensitive Sort?

From: Mario Perreault <mario.perreault_at_informission.ca>
Date: Wed, 15 Jul 1998 12:09:05 -0400
Message-ID: <35ACD421.BA837E0D@informission.ca>

Just try this :

select col_name from table_name
order by upper(col_name);

Mark Tortolano wrote:

> Hi,
>
> Does anyone know if it is possible to sort ASC in a query without
> taking the case into account? My users are complaining that they want
> the query presented in asceding alphabetical order without the case of
> the field having an impact on the ordering.
>
> Thanks,
>
> Mark Tortolano

--

            \\\\|||//
            /  ^ ^  \
           (  0 0  )

---oOOo-(_)-oOOo-----
mario.perreault_at_bigfoot.com
mario.perreault_at_informission.ca
tel: (418) 627-0999 #205
fax: (418) 627-2023 Received on Wed Jul 15 1998 - 11:09:05 CDT