SUBSTRING Query (9 day n00b question)

_DanielB_

Hi

I've only been using Domo for about 9 days so still very new to this but I am trying to use the SUBSTRING function to return the values in my ID column to ignore everything before and including and underscore as this value varies in character size (example EN_, ENR_, ENO_)

How do I get the ID column to return the values after the _ ??

Thanks for any and all support

DanB

ColemenWilson

SUBSTRING_INDEX(ID, '_', -1)