How to replace the specific pattern in the string.
Posted on 2009-07-14
I have a column in the table of type varchar and usually the column contains the values like :
In the above values, I want to remove/replace the values which end with '/A1', '/A2' ........ '/A9'
i.e 238905934/A1 --> 238905934
The number followed by '/A' can be between 1 to 9. Can I do this with replace function using pattern matching.