You mean works incorrectly. LOL. F Sent from my Verizon Wireless BlackBerry
-----Original Message----- From: Joe D'Souza <jdso...@shyle.net> Date: Wed, 14 Apr 2010 13:25:31 To: <arslist@ARSLIST.ORG> Subject: Re: Extracting digits from a character field You are right, I just tried and it sets the whole column to NULL instead of just replacing the specific characters in expression 2 to NULL.. It works correctly in Oracle to the best of my knowledge.. Joe -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org]on Behalf Of Jim Fox Sent: Wednesday, April 14, 2010 1:00 PM To: arslist@ARSLIST.ORG Subject: Re: Extracting digits from a character field Replaciing a character with Null is an oxymoron in MS-SQL. You would replace a character with a zero-length string. Null and "" are not the same. Fluxman Sent from my Verizon Wireless BlackBerry -----Original Message----- From: Joe D'Souza <jdso...@shyle.net> Date: Wed, 14 Apr 2010 11:42:21 To: <arslist@ARSLIST.ORG> Subject: Re: Extracting digits from a character field Jim, Just curious.. What are the limitations that you encountered replacing a character or a string with NULL on MS-SQL.. And what version of MS-SQL?? Joe -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org]on Behalf Of Jim Fox Sent: Wednesday, April 14, 2010 11:12 AM To: arslist@ARSLIST.ORG Subject: Re: Extracting digits from a character field On MS-SQL, trying to replace one character with Null is not a good idea. Fluxman ------Original Message------ From: Joe D'Souza Sender: Action Request System discussion list(ARSList) To: arslist@ARSLIST.ORG ReplyTo: arslist@ARSLIST.ORG Sent: Apr 14, 2010 11:07 Subject: Re: Extracting digits from a character field 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"