Select  reverse( left(reverse(address),position(' ' in reverse(address))))HOUSENR, 
right(concat('0000000',p.patnum),7) spatnum , p.* from patient p   where p.patnum = <@PATNUM@>
