Good Morning Everyone,
I have stored salary amount as varchar in my table and now i need to convert into currency format with "$" sign. I have wrote following funciton to convert the datatype
'$'+ Convert(varchar,Convert(money,Salary),1)
This converts 50000 into $50,000.00
Now i need to get rid of decimals at the end so that $50,000.00 will display as $50,000
What function do i need to use to get rid of decimals ?
Thanks