trim string to everything after:

I need to trim this string to everything after the :
the string is:


What I want left is .07 and then to convert it to a double.
Who is Participating?
Terry WoodsConnect With a Mentor IT GuruCommented:
You can get the value .07 like this:
select substr(my_column, instr(my_column , ':' ) +1)
from my_table

Open in new window

(tested and working)
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.