How to remove comma and convert in to INT

• kiran.rajenimbalkar

  SSCrazy

  Points: 2603

  More actions

  June 17, 2013 at 4:40 am

  #275309

  Hi,

  How to remove comma and how to convert this column into [numeric](17, 2) this formate.

  I have conevrt my this column values in this format [numeric](17, 2) NULL now this column have nvarchar datatype in my source.

  Please sugget

  drop table dataconvert

  go

  create table dataconvert

  (data nvarchar(15))

  insert into dataconvert values('$0')

  insert into dataconvert values('$40,000')

  insert into dataconvert values('$2,350')

  Regards,

  KRaj

• Kingston Dhasian

  SSCoach

  Points: 19799

  More actions

  June 17, 2013 at 4:57 am

  #1624535

  There are 2 ways to do this

  SELECTCONVERT(NUMERIC(17,2),REPLACE(REPLACE(data,',',''),'$',''))

  FROMdataconvert

  SELECTCONVERT(MONEY,REPLACE(data,',',''))

  FROMdataconvert

  ---

  Kingston Dhasian

  How to post data/code on a forum to get the best help - Jeff Moden
  http://www.sqlservercentral.com/articles/Best+Practices/61537/

• kiran.rajenimbalkar

  SSCrazy

  Points: 2603

  More actions

  June 17, 2013 at 5:12 am

  #1624542

  Thanks Sir..

  Its worked thanks for your help