Need to use USER.FULL_NAME in URL string but it breaks up the link. Help!
I'm sending a link, "on ticket close", via email. I am populating the link with bits of info from the ticket. I need to use full name (versus user name) in the link but, the space between first name and last name breaks it. We use the email format firstname.lastname@example.org, so using the submitter's email address after trimming everything including the atmark from it would work but alas, quoting the full name or stripping characters from a returned string is far beyond my feeble SQL capabilities.
Any suggestions would be most appreciated.