SQL Server: Can i use the distinct keyword on a portion of a column?
Posted on 2010-08-16
I have a column in a table with data such as:
I'd like to return distinct values that occur in the table on the left hand side of the "/" for slash. So the query should return the values:
I appreciate it would suggest having seperated it in 2 columns but please presume that that is not possible at this moment. The application code could do this but wanted to know if SQL could query this information.
Many thanks =)