If you are in an Oracle database, use the function TRANSLATE to replace all Alpha characters with either NULL or space or whatever else you wish to.. This will leave the string with only special characters and numerical characters..
I am not sure if TRANSLATE works on MS-SQL but you could give it a shot if MS-SQL is your underlying database. Joe -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org]on Behalf Of Atul Vohra Sent: Wednesday, April 14, 2010 9:42 AM To: arslist@ARSLIST.ORG Subject: Extracting digits from a character field I have a free form character field and need to extract digits from that field - may be in a filter? Am on v7.1, oracle. Any one has some function they used (like in sql or may be combination of strstr??) Looks painful to me. Help please Atul _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
