RE: SQL : convert string to integer

[Don Read]

On 26-Oct-00 magali lacombe wrote:
> Hello,
> 
> I have a SQL request that use the integer(myString) function.
> select * from mytable order by integer(id);// id is a varchar made of
> numeric character integer() give me the right order
> 
> Is there a way to do that with mySql  ?
> 

select *,id +0 as odr from my_table order by odr;

Regards,
-- 
Don Read                     dread@stripped
There are old sailors, and there are foolish 
sailors; but damn few old foolish sailors.
---------------------------------------------