hi, i need to split address field in my database into street#, direction (N/S/E/W), Street NAME, designated field(apt/ste/etc), desig # into seperate fields. right now everything is in one field. data i have is not standard. can someone help me on that?