Re: How to add leading zeroes

On May 6, 1:48 pm, "lenygold via DBMonster.com" <u41482@[EMAIL PROTECTED]
> wrote:
> Thank' s everybody for help.
> The reason why i need this conversion is to sort the following rows:
>

I didn't realize that it was sorting that you where after. The
following post by Vadim is an alternative way of attacking traversal
of a tree, and therefor might be of interest to you.

http://groups.google.com/groups?as_umsgid=22d2e427.0308172007.7eb298f@[EMAIL
PROTECTED]
 total ordering is defined as:

6. For any nodes A and B we write A > B whenever
 i. B is Ancestor of A or
 ii. there exists node B' which is an ancestor of B,
     and A' which is an ancestor of A,
     and both A' and B' having the same parent,
     and A' > B'

/Lennart