I have a column in a base table of varchar type which is expected to have only numbers( positive, negitive, decimal and zeros).But it also contains character values (e.g ‘SAMPLE’, ‘NODATA’) i am trying to create a view which uses this column and I want to replace any character type clues in the column to be replaced with 0 and leave the numbers as is.
How to achieve this?