Currently, I change a user's password as follows:
ls_SQLText = 'sp_password ' + sapass + ', ' + newpass + ', ' + is_user
EXECUTE IMMEDIATE :ls_SQLText;
That works fine EXCEPT...
if sapass or newpass contain special characters (pretty much anything but an alpha or numeric).
How can I change the command to handle special characters?