Need an SQL code that replaces unvisible tailing spaces to something visible like "_P" in a table's

[AN_10548594]

I am using Windchill PDMLink Release 12.0 and Datecode with CPS 12.0.2.11

Need an SQL code that replaces unvisible tailing spaces to something visible like "_P" in a table's column. Example - given value "123456 " should be "123456_P".

[Ajit_Kulkarni]

Hello,

Use replace function in SQL. 

https://www.techonthenet.com/oracle/functions/replace.php

https://www.oracletutorial.com/oracle-string-functions/oracle-replace/

Thanks!! 

[cgautier]

Hello AN_10548594,

I'm Charles from PTC Technical Support in Europe, I will provide you assistance on this question.

Did you review the information shared by Ajit_Kulkarni ?

I remain at your disposal for any questions or concerns.

Kind Regards,

Charles Gautier.

[cgautier]

Hello AN_10548594,

With your agreement I propose you to let this question still open for a few days and then close it by the end of the week.

KR,

Charles.