To: Steven Ducat; [EMAIL PROTECTED]
> Subject: Re: SELECT 9 BETWEEN 1 AND 0
>
>
> I am sorry to say that your question is not clear.
> Why don't you send us a simple Table with few data and what
> you want to
> achieve in simple terms? I mean a more clear question!!!
>
This went direct and not to the list.
Andy
-Original Message-
From: Andy Eastham [mailto:[EMAIL PROTECTED]
Sent: 21 October 2003 08:19
To: Steven Ducat
Subject: RE: SELECT 9 BETWEEN 1 AND 0
Steve,
I'd add an extra column with "modified code" in it, where I subtracted 1
ginal Message -
From: "Steven Ducat" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, October 21, 2003 08:12
Subject: SELECT 9 BETWEEN 1 AND 0
> I am trying to create a select query to find the post town of a users
> post code. I am using Royal Mails (UK)
I am trying to create a select query to find the post town of a users
post code. I am using Royal Mails (UK) post town gazetteer. UK Postcode
(eg. RH6 9XJ). The first column contains the first half of the post code
(eg. RH6) and the next column holds the range of the second half (eg.
2AA-6PP).
I
