| Subject | Re: [firebird-support] need to get all the distinct first letters of entries in a column. |
|---|---|
| Author | Doug Chamberlin |
| Post date | 2003-09-15T21:09:30Z |
At 9/15/2003 04:18 PM (Monday), rs_ravipati wrote:
and I'm sure you can adapt it.
select distinct substring(description from 1 for 1) from document
>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