Arif Khan
SSC Veteran
Points: 291
More actions
June 1, 2004 at 8:37 pm
#83004
Is there a way to display 100 as +100 in TSQL.
SQLBill
SSC Guru
Points: 51440
June 2, 2004 at 7:15 am
#508648
The only way I know is to make it a string:
SELECT '+' + (CAST(100 AS VARCHAR(3)))
-SQLBill
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply