Re: PeopleSoft - format PHONE number

[Carlton Conley <cconley@CDG-INC.COM>]

is the phone number being stored in your data base with the characters or
just displayed on the panel in the PS format?  In Oracle the numbers are
stored with out the characters and need no stripping out of characters.

-----Original Message-----
From: Morris Hicks [mailto:MorrisHx@AOL.COM]
Sent: Wednesday, November 08, 2000 10:49 AM
To: SQR-USERS@list.iex.net
Subject: PeopleSoft - format PHONE number


Is there a delivered SQC in HRMS or a function I can use to strip out any
special characters from a character field?
i.e.
713-380-1244
713/3801244
713 3801244

should all produce 7133801244

Thanks.... Morris
ps - this is for an outbound SQR interface.

*********************************************************************

This e-mail message is confidential, intended only for the named
recipient(s) above and may contain information that is privileged, attorney
work product or exempt from disclosure under applicable law. If you have
received this message in error, or are not the named recipient(s), please
immediately notify ESPN at (860) 766-2000 and delete this e-mail message
from your computer, Thank you.

*********************************************************************