Hi

i'm a newbie of SQL

I need a SELECT with GROUP BY on first char of field.

like this : SELECT * from clients GROUP BY LEFT('NAME',1)

EDB 2

Any Hint ?

> I need a SELECT with GROUP BY on first char of field.
>=20
> like this : SELECT * from clients GROUP BY LEFT('NAME',1)


This looks like it worked for me: SELECT * from clients GROUP BY =
LEFT("NAME",1)

Try changing your apostrophes to quotation marks.


jr