select
CONVERT(money, CASE WHEN [Column ] LIKE '%-%' THEN '-' + replace([Column ], '-', '')ELSE [Column ] END) AS TransCurfrom
Test_Table
CONVERT(money, CASE WHEN [Column ] LIKE '%-%' THEN '-' + replace([Column ], '-', '')ELSE [Column ] END) AS TransCurfrom
Test_Table
No comments:
Post a Comment