hi all,

I'm facing a critical problem with SQL Server.

I'm saving a data in to numeric field as 1,000. It saved correctly but when I retrieving it, will become 1. If it is 10,000 return as 10.

My server is windows server 2003. When I'm doing the same process, it's retrieved correctly. I'm facing this problem only in windows server 2003. I'm using sql server 2000.

Can any one tell me what could have happened?

__________________
S.VinothkumaR
Behind me is infinite power,
Before me is Endless Possibility,
Around me is Boundless Opportunity,
Why should I fear!