CLEAN up data

[mike2000]

is there any functions in Oracle where I can filter the data out. For example, if I have the data in 1 column and there are lot of crap in there let say:

1800,
210a,
202b,
2000

Is there a function for me to pick only the number data??? Anything else we can trash

thanks

[marist89]

To me, the best way would be to write a function. That way, you'll have total control over how you want your data to be handled.