Rocky,

R> I have a simple select statement in my stored procedure and I want to
R> eliminate multiple occurence of field values in the resultset. What
R> would be the best approach to this type of problem?

here's what I'd do:
- code the select statement as a "for select" loop.
- keep track of the value of NAME at each iteration.
- while it equals the previous value, substitute it with '-' or
whatever.

Ciao
--
Nando Dessena
http://www.flamerobin.org
======================================================
I support Firebird, I am a Firebird Foundation member!
Join today at http://www.firebirdsql.org/ff/foundation
======================================================