Oh and another set of prefixes to look for are "upper" and "lower" as well as "Royal"
eg Lower Peover Royal Tunbridge Wells http://en.wikipedia.org/wiki/List_of_place_names_with_royal_patronage_in_the_United_Kingdom http://en.wikipedia.org/wiki/List_of_generic_forms_in_place_names_in_the_United_Kingdom_and_Ireland Dave -----Original Message----- From: ProFox [mailto:[email protected]] On Behalf Of Stephen Russell Sent: 24 June 2014 14:32 To: ProFox Email List Subject: Re: [NF] UK address correctness On Tue, Jun 24, 2014 at 2:58 AM, Dave Crozier <[email protected]> wrote: > Yes, > County and Postcode are usually placed together on the last line of > the address > > <Name> > <Address 1> > <Address 2> > <Locality> > <County <Postcode> > > ------------------ I appreciate that. Is there a rule for use of the word "upon" in address as well? Looking at Kingston upon Hull HU9 5EX One of my ship to addresses that our old reports does. The data in the db has no reference to Kingston upon. I only see Hull and then the postal code in the data presented so far. We paid the vendor for the custom version of our UK BOL report. I am replacing it with a SSRS version that also calls a Certificate of Analysis sub report allowing our staff less key strokes at releasing the truck. -- Stephen Russell Sr. Analyst Ring Container Technology Oakland TN 901.246-0159 cell --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
