Re: Ordering by a number, date or text

> First I would like to thank the person who gave me help figuring out my
> decode in order to sort by, sorry I can't give a name, but I can't access
> hotmail from work and that is where my mail is. I really appreciate it. When
> i can access hotmail I will thank you by name.
>
> Ok now to my second part, now I am at the point where after passing a
> parameter to my report I can order the elements in my list but I have a
> problem. When I send the parameter I check a it's value and then place the
> cirteria it is to be ordered by in the order field. My problem is that when
> I do this the order is treating my numbers as text/characters and
> subsiquintly when sorting personel by hours they have placed in a job, a
> person with 23 hours comes before someone with 6 while someone with 2 hours
> comes before the person with 23 so the order is ordering by the first
> character, and I need it to order by the value of the number. Does anyone
> know why thus might be happening? Yes my hours are set as a number, i think
> it has something to do with the fact that the parameter is a string, could
> that be the problem??

Try TO_NUMBER() and see if it solves the problem.

Daniel A. Morgan Received on Thu Mar 08 2001 - 00:27:14 CST