Hello,
You can use function translate
testdb011=# select translate('XY1X234X','qwertyuioplkjhgfdsazxcvbnmQWERTYUIOPLKJHGFDSAZXCVBNM',''); translate----------- 1234(1 row)
RegardsPavel Stehule