I didn't design the DB, and at this point, I'm screwing with it as
little as possible.
But yeah, that's a good idea for next time.
--benD
Jochem van Dieten wrote:
> Ben Doom wrote:
> >I've got a similar problem (where I have to sort by a length expressed
> >as "11 inches" or whatever).
>
>
I've got a similar problem (where I have to sort by a length expressed
as "11 inches" or whatever).
Can you do something like "order by char_length(pk), pk"? That's how I
got around the problem.
--benD
Stephenie Hamilton wrote:
> hey guys, anyone here familiar with db2? we are just starting
hey guys, anyone here familiar with db2? we are just starting work on
a fb project and the dba setup the pk field as a text field we
can't get ahold of him until next week and now if we try to use MAX()
to get the highest number, it thinks 9 is higher than 10 (because it
is text), but i was wonder