>Hello Tore
>Thank you for your quick answer.
>The first select goes to an HP-3000 with an image database.
>cast() is not supported !!!!!!!
>
>What is wrong with my last select (round(vkpreis / 1,2) as vkpreis from mydata) ??
>
>Best regards
>Albert
What version of MySQL you use? Because I just read that in MySQL v.5.0 CAST function is supported:
http://dev.mysql.com/doc/refman/5.0/en/cast-functions.html
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.