I want to replace characters in a char field with blank within a select query. For example :
SELECT REPLACE(objnr, 'OR', '') AS OrderNo FROM COSP
How to achieve this ?