#DateForumTypeThreadPost
426 Aug 2011 @ 05:20 PDTUDAReplyHow to remove non-numeric characters from a string? (Oracle TRANSLATE Equivlent function?) Thanks Rluebke for your comment.  Do you know what could be alternative solution?  - Anand  
322 Aug 2011 @ 02:31 PDTDatabaseReplyhow to capture mismatched recordsI have two columns in a table. I want to extract the matched part of strings in these two columns. Please help.
222 Aug 2011 @ 01:35 PDTDatabaseTopicHow to extract numbers from string using teradata functions, operators?I have a column that has both numbers and texts in the fields. Examples: xyz 120 abc lmnop xy 120 120 Null ?/ 567 abc .... 233 As you can see the fields can have numbers, texts, spe...
121 Aug 2011 @ 11:59 PDTUDAReplyHow to remove non-numeric characters from a string? (Oracle TRANSLATE Equivlent function?)I want to re-write the query given below (I found this query in a forum Link - http://blogs.lessthandot.com/index.php/DataMgmt/DataDesign/extracting-numbers-with-sql-server): Select Left(SubStri...