I have the following line in my stored procedure :
SET @ErrMSG = 'Employee : ' + STR(@Employee) + ' Only Has ' + STR(@AllowanceLeft) + ' days left to take.'
When I debug through to the @AllowanceLeft part, it shows as 2.5000
However, this message displays it as 3.
How do I stop it rounding up please ?