Anyone how to get a volume name with the ID?

Question

This is what I always seem to get in my alerts no matter what volume name variable I use.

D: \ Label:APPS cc18254b

I want the ID to do away or whatever the hell that is at the end.

mrxinu · Accepted Answer

You can use an SQL variable to get the drive letter only. Try putting this in the email message:

${SQL:Select Substring ('${Caption}',1,3)}

That should convert 'C:\ Label:APPS cc18254b' to 'C:\'.