Hello,
I have data like this in a column:
Word1 Word2 Word3
Word1
Word1, Word2
And I want the select statement to return the line without first word OR keep it as is if there's only one word in a line. Like:
Word2 Word3
Word1
Word2
So I'm thinking that we look into the line "return all data after , or SPACE" and "leave it as is if there's only one word" (should be so that there's no empty space after the only word).
Is it possible to do something like this with one select query? What would be a good solution?