ems to sort to the end (the numbers
now start with '0')
Pasha's solution is probably cleaner, but you have to change the
table definition. For Pasha's solution to work, you would need to
have the text_val column be null (or '') when the value is numeric.
Sub
> OK, I'm sorry. The solution I gave doesn't work.
>
> You need to have some sort of conditional in the sort expression so
that
> numbers are sorted numerically and other things are sorted >
> alphanumerically.
> I'm not aware of a test for numeric vaues in MySql, so you need to use
>
> some
> tr
bers
now start with '0')
Pasha's solution is probably cleaner, but you have to change the
table definition. For Pasha's solution to work, you would need to
have the text_val column be null (or '') when the value is numeric.
> Subject: Re: So
That didn't do it. I got 0,0,1050,1168,1195, 1975, 150,155,16500,170,178.
. . The non-numerics came out last (which I want). There are two zeros
but no negative numbers. Any alternatives?
Ken
**
On Wed, 12 May 2004 07:47:11 -0400, Bill Easton <[EMAIL PROTECTED]>
wrote:
You could also
[EMAIL PROTECTED] wrote:
How do I set up a column (cost) that contains numbers and text so that
the numbers will sort the numbers accurately? Using varchar results in
a sort based on the first digit, so that I get e.g. 1, 10, 100, 3. . .
when the command is "order by cost." Almost all of the te