Tuesday, 25 October 2011

Convert Varchar to Money datatype where data ends with "+" or "-" using CASE statment

select
CONVERT(money, CASE WHEN [Column ] LIKE '%-%' THEN '-' + replace([Column ], '-', '')ELSE [Column ] END) AS TransCurfrom
Test_Table

No comments:

Post a Comment