|
Re: Query postcode issue?
Nice solution
Ideally, the seperate post code parts would reside in different database fields, but as they do not you need to work around it differently.
Either have SQL handle trimming off the last elements, or do it once the result-set has been returned.
You can with PHP, or ASP or whatever trim everything from the post after and including the space.
__________________
Rob - SEO Specialist
Owner & Founder of Webforumz.com
I am currently unavailable for private work
Last edited by Rob; Feb 21st, 2008 at 12:16.
|