I am trying to return a string up to a certain character, and cannot figure out what I should be using. This may be a newbie question...
Basically, a varchar(255) column named COMMENT has the following value:
'Working on a solution to get this to appear_NOT THIS'
When I select that column I would like the result to be
'Working on a solution to get this to appear'
So effectively trimming everything to the right of the _ (underscore).
Is that even possible?