rahulsony111
Hall of Fame
Points: 3865
More actions
September 25, 2010 at 3:06 pm
#387862
Hi i have a column with a values like 'abcd+1.23', 'xd+2.3%','oracle+1.65'
i want to have my target values have the number after plus sign like '1.23', '2.3', '1.65'
please let me know how i can achieve.
September 25, 2010 at 4:23 pm
#1227405
Hi guys, i got it. used charindex function in substring function
thankyou all
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply