Hi
I am trying to write a search query on USA zip code. What I need to do is only query the beginning of the zip code, eg, if someone tyes 61 in the search box it would only return those zipcodes beginning with 61 and not items that contain 61.
Hope this makes sense.
I created a %LIKE% query but this did not work.
Can anyone give any help.