View Single Post
  #3 (permalink)  
Old Feb 21st, 2008, 12:14
Rob's Avatar
Rob Rob is offline
Head Admin & CEO

SuperMember
Join Date: Jul 2003
Location: at my desk
Age: 34
Posts: 2,952
Blog Entries: 7
Thanks: 7
Thanked 4 Times in 4 Posts
Send a message via MSN to Rob Send a message via Skype™ to Rob
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.
Reply With Quote