Skip to Content
0
Nov 06, 2020 at 10:02 AM

Replace Characters in Char field in Select Query

1581 Views

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 ?