How can I trim certain characters in a query?
I have a column that had some records containing the value: 12345-123
I only want to select the characters before the dash.
So I want to trim the dash and all characters at the right of the dash.
(So it returns the value: 12345)