Subject Re: [firebird-support] need to get all the distinct first letters of entries in a column.
Author Doug Chamberlin
At 9/15/2003 04:18 PM (Monday), rs_ravipati wrote:
>I need to get a set of all distinct first letters in a column.

Here is a SQL command I just tried in my Firebird 1.03 system. Worked fine
and I'm sure you can adapt it.

select distinct substring(description from 1 for 1) from document