In SQL Server you can use REPLACE: REPLACE ([myColumn] , ',' , '') -- remove comma
Then you should be able to cast. Jim On Wed, Apr 15, 2009 at 8:37 AM, 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 >
