I need to establish a replace characters function that can be referenced during a query. I am not updating a table, but rather just displaying the desired replacement character in the query results. I will basically display the field in the query like this--
'Replaces the "|" with "-" If the "|" character is present
Help is appreciated!!!