List:General Discussion« Previous MessageNext Message »
From:Gary Smith Date:April 24 2012 4:31pm
Subject:Re: Postal code searching
View as plain text  
On 24/04/2012 17:24, Tompkins Neil wrote:
> How about if I want to only return postal codes that are like W1U 8JE
> not W13 0SU.
>
> Because in this example I have W1 as the postal code and W13 is the other
> postal code
Then you'd do:

like 'W1 %' to return anything starting W1
like 'W13 %' to return anything starting W13.
like 'W1U %' to return anything starting W1U.

It's the location of the space before the wildcard that's important 
here. The space is taken as part of the known element of the string.

Gary
Thread
Postal code searchingTompkins Neil24 Apr
  • Re: Postal code searchingGary Smith24 Apr
    • Re: Postal code searchingGary Smith24 Apr
      • Re: Postal code searchingTompkins Neil24 Apr
        • Re: Postal code searchingGary Smith24 Apr
        • Re: Postal code searchingLars Nilsson24 Apr
        • Re: Postal code searchingMark Goodge25 Apr
          • Re: Postal code searchingAndrew Moore25 Apr
          • Re: Postal code searchingTompkins Neil25 Apr
          • Re: Postal code searchinghsv25 Apr
          • Re: Postal code searchinghsv25 Apr
  • RE: Postal code searchingRick James24 Apr
    • Re: Postal code searchingNeil Tompkins24 Apr
      • Re: Postal code searchingGrant Allen24 Apr