No easy way...because is has ',' in it. Try to remove it, then use CAST or CONVERT
On Wed, Apr 15, 2009 at 8:37 PM, vikas arora <vikas.arora....@gmail.com> wrote: > hi every one, > > i face a problem in sql server2000 > > when i convert a varchar value '12,234' to int > > plz help > -- Best Regards, David Shen