sql - Substring of character to numeric as well as parsing in a join -

i trying inner join in proc sql on 2 variables in 2 different formats, , 1 needs parsed. example 1 variable in 1 table 123sampleev , other variable in other table 123. need join on 123 can't figure out how substring , convert character numeric in same statement. possible?

yes, can.

in oracle can use substr() function portion of string want , can to_number() convert number. i'm sure there similar way other database types.