> So I need something like
>
> Select
> "First 12 digits",
> Count(*)
> from table
> group by 1
>
> Can this be done in SQL ?
>

Sure, you can use substring(col from 1 for 12) or left(col, 12). The latter is available in 2.1.

Sasha