I can try it, but it is Primary Key of table, so I will try on other column, which is not PK. Then I can send conclusion.

Thaks

You are right if we can use parametrised queries it will be easier to control datatypes, but our app was written in PB :-(.

Current version of our application is in...

to: alzbda

I know that is better to use correct datatype. I mean datatype which is in table definition, but Our application wa written in PowerBuilder 6.5 and runtime of PB...

To modify the application it takes cca 1 month. Why we are using decimal (10,0) instead of bigint or int because column bigint takes more disk space instead of decimal...

we use adhoc queries. I know that the solution is to sen number without .00, but we cannot do that. Because it sends PowerBuilder from their api (I think). I'm...