Further information to this issue. I have tried using cast in my sql and casting it to a decimal with no luck. I've written a script that says select 2.50 from [tablename] and then logged to a file the value in dataset column 1 and I still get 2.5 can I test if there is only 1 character after the decimal place? I can check if the value includes the decimal, but can I check how long a variable is? |