Re: Postal code searching

[Gary Smith]

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