Thanks Nando,

Just the way I expect the resultset would be. I just have to create a
temporary variable to store the oldName so i can compare it with as
the record iterates.

Again thanks,

-rocky

On 7/21/05, Nando Dessena <nando@...> wrote:
> 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
> ======================================================
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://firebird.sourceforge.net and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
>
>
> ________________________________
> YAHOO! GROUPS LINKS
>
> Visit your group "firebird-support" on the web.
>
> To unsubscribe from this group, send an email to:
> firebird-support-unsubscribe@yahoogroups.com
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
> To unsubscribe from this group, send an email to:
> firebird-support-unsubscribe@yahoogroups.com
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
> ________________________________
>


--
"When you are not practicing, remember, someone somewhere is
practicing, and when you meet him he will win. "
-Ed Macauley