You are viewing this site as a guest. You can still ask questions and help others! Join our Dev2Dev IT Community to receive your own blog, share your knowledge, and much more.

email functionality in SQR

2 replies [Last post]
Guest's picture
Guest

I am having email delivery failures where the email address contail the "&" sign.So ANY e-mail address containing an ‘&’ symbol is not recognised . I am using SQR report to send the orders. Can you help me out

Lepa's picture
User offline. Last seen 2 years 2 weeks ago. Offline
Joined: 06/23/2008
Posts: 591
Re: email functionality in SQR

You are saying an email address with & is a valid email address? if so, then use the character function to pass the & value as an ASCII number. Can't remember what the function is in SQR but it should be something like chr(38) or char(38). 38 is the sign &

Give back to the community and help it grow!
* Help with unanswered forum questions and issues
* Register or login to share your knowledge at your own blog

Guest's picture
Guest (not verified)
Re: email functionality in SQR

hi,

Is this code will work in SQR

let $replaced = replace($email, '&', '^&')

Please let me know