var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Parsing Varchar2
I need to parse out some alphabetic characters from a Varchar2 field to leave only the number values. The field values look like this $40-35 or say $40$35.
Is there a sql function or statement to do this. Any help is greatly appreciated.
the good 'ol select replace should get the job done.
just write a statement to replace the $ and/or -
a generic example follows:
SELECT REPLACE(column_name, 'old_value', 'new_value') FROM table_name
given your example of input what would you expect the output to be? select replace could work but it will depend on the complexity of your substitutions.