I have a field called "zip". The user enters a full 5 digit zip code in the field. My script & SQL statement then accesses the database and shows all the matches for that full zip code. What I want to happen next is perform a search on just the first 3 digits of the zip code to give a regional results list. How do I manipulate my "zip" field to only contain the first 3 digits. I am an RPGIV AS/400 programmer who is new to vbscripting. I do not know of an opcode to let me do this. Thanks for your help!
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.