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 <[email protected]> Date: Wed, 14 Apr 2010 11:42:21 To: <[email protected]> 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:[email protected]]on Behalf Of Jim Fox Sent: Wednesday, April 14, 2010 11:12 AM To: [email protected] 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: [email protected] ReplyTo: [email protected] 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:[email protected]]on Behalf Of Atul Vohra Sent: Wednesday, April 14, 2010 9:42 AM To: [email protected] 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"
