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:\'.