SQL Query Returning First Letter

I need an SQL query that distinctly returns the first letter of each value in the column.

Here's an example:

Column A has the following values:  baseball, football, soccer, swimming
The new query would return the following:  b, f, s

I'm using Oracle 10G.
Who is Participating?
sdstuberConnect With a Mentor Commented:
select distinct substr(A,1,1) from your_table
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.