On Tue, 14 Aug 2001 16:24:43 +1200, Andrew McMillan wrote:
>> SELECT t6.* FROM RECHNUNG t6 WHERE t6.bruttosumm = 00000034.70 ORDER BY t6.nummer DESC
>
>Can't you just force conversion of the constant to numeric?
>
>SELECT t6.* FROM RECHNUNG t6 WHERE t6.bruttosumm = numeric(00000034.70)
>ORDER BY t6.nummer DESC
>
As I said, my application is doing it. Only thing I did, was patching the ODBC-driver
to put quotes. That is the same like your proposal. But since I can't change my app.
I'm, looking for a smarter way.
Thanks anyway
Johann
Johann Zuschlag
zuschlag@online.de