hi all, is there any shorthand to extract the string part of a varchar field only? like when having german street addresses (e.g. foostreet 23) in a varchar field and i want to select the non-numeric part of it (foostreet) only?
thanks, best: lars
hi all, is there any shorthand to extract the string part of a varchar field only? like when having german street addresses (e.g. foostreet 23) in a varchar field and i want to select the non-numeric part of it (foostreet) only?
thanks, best: lars