I NEED SQL COMMAND TO EXTRACT THE NUMERIC VALUSE IN BETWEEN THE STRINGS
Home > IT Answers > Development > I NEED SQL COMMAND TO EXTRACT THE NUMERIC VAL...
UUKKY
15 pts.
0
Q:
I NEED SQL COMMAND TO EXTRACT THE NUMERIC VALUSE IN BETWEEN THE STRINGS
SQL commands, SQL
VCH:FR:AUD/120.18/51.26YQAC/1.35QKAD/14.47QRCO/14.47QREB/1.35QKSB/6.00WGSE/20.91UOVZ

I NEED TO EXTRACT THE VALUES IN THE ABOVE STRING AND SUMM ALL THE VALUES USING SQL COMMAND

EX:120.18+51.26+1.35.....IN THE ABOVE GIVEN REFRENCE



Software/Hardware used:
SOFTWARE
ASKED: Oct 17 2009  5:21 AM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
UUKKY
15 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
Last Answered: Oct 17 2009  5:21 AM GMT by UUKKY   15 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

mrdenny   46795 pts.  |   Oct 17 2009  10:15PM GMT

Using what language and what platform?

This is something which would be better done using a regex expression in the client not in the database.

 

UUKKY   15 pts.  |   Oct 19 2009  2:55AM GMT

i want to write using
Structured query language in Teradata
platform is dataware house

 

Meandyou   1840 pts.  |   Oct 19 2009  1:55PM GMT

mrdenny is correct; better to do this in code rather than an SQL statement.

SQL is best suited for processing individual columns as opposed to parsing a string of data.

 
0