In message <[EMAIL PROTECTED]>, edgardo
catorce <[EMAIL PROTECTED]> writes
>I tried this query
>
>$sql = mysql_query("SELECT * FROM tblPlantilla ORDER
>BY left(itemNumber, instr(itemNumber, '-')),
>mid(itemNumber, instr(itemNumber, '-')+1) ASC");
Something like
BY cast(left(itemNumber, instr(itemNumber, '-')) AS DECIMAL),
CAST(mid(itemNumber, instr(itemNumber, '-')+1) AS DECIMAL) ");
I don't know, I haven't had to use anything like this, it's bad database
design.
--
Pete Clark
Sunny Andalucia
http://hotcosta.com/Andalucia.Spain
