excellent, thanks for your help

Something has just cropped up.

The statement works as it should and exports the post code area. However my historical data is not that good. I would like to include all...

Thanks for your help

Just check the data, you are right some don't have numbers.

Thanks for your help,

Is there a way around the error is the field doesn't have any number?

Yes, our post code are like AA1 1SS, or B1 1SS

I just need the AA or B part of the code

Thanks

Thanks for the quick reply

When I try your code I get

Invalid length parameter passed to the LEFT or SUBSTRING function.

as a error

Thanks