COLLATING SEQUENCE (EBCDIC to ASCII)

Does anyone know how to change collating sequence in Oracle, either at the database level or for a specific query?
We have a mainframe (ebcdic) app that is converted to NT (acsii) and some special characteres (e.g. period(.) dash (-) etc.) not sorting properly.

If using functions, please show example,

Thanks

John Baylis
Database Administrator
Canadian Forest Products Ltd.
Vancouver B.C. Canada

> (604) 697-6476 (Office)
> (604) 313-6054 (Cell)
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Baylis, John
  INET: JBaylis_at_mail.canfor.ca

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).