In SQR, how do I remove special character from a selected field and replace it with a space.

I am writing an SQR and extracting data from a PeopleSoft record and creating a text file.  One of the fields is PS_LAST_NAME and I need to exclude the hyphen from the name and print a space instead.
Who is Participating?
VanBroConnect With a Mentor Author Commented:
I found resolution....translate
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.