I do not have access to an Oracle instance at the moment to try it, but I'm
quite sure that
update tablename set columnname = REPLACE('Does work', 'Does ', NULL);
commit;
would update the column to 'work'. Which is ideally what you would want it
to..
With MS-SQL it sets the column to NULL.
Joe
-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:[email protected]]on Behalf Of Jim Fox
Sent: Wednesday, April 14, 2010 2:03 PM
To: [email protected]
Subject: Re: Extracting digits from a character field
You mean works incorrectly. LOL.
F
Sent from my Verizon Wireless BlackBerry
-----Original Message-----
From: Joe D'Souza <[email protected]>
Date: Wed, 14 Apr 2010 13:25:31
To: <[email protected]>
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:[email protected]]on Behalf Of Jim Fox
Sent: Wednesday, April 14, 2010 1:00 PM
To: [email protected]
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 <[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"
