Hello All,

I am trying to find a way to parse a string in a field. I would like to select just one character from the field based on its position. The string has this form: 'a:a:datatable'

Is there a way to perform a Select that would retrieve the values after the ':'?

Thanks

select substr(column,instr(column,':')+1,1) as value from table ;