I've created a few advanced alerts with variable ${VolumePercentUsed} in the email but i'm getting it in the format below to 5 decimal places. Is there a way to change it to like 1 decimal place?
78.48357 %
${SQL:Select Convert(varchar,Round(Left('${VolumePercentUsed}',6),2)) ;}%
Thanks for your help julrich.