hi all, i'm looking for a function to extract the string part of a varchar field only. like when you stored an street address in one field like "foobar street 23" and i want everything except the numeric value of it.
is it possible without a regexp? if not, anyone has a regexp for that purpose handy? thanks: lars