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 my data as it is, which included just letters or even a decimal place. This is due to a poor set of data which was imported from a old system.

Is it possible to have a select statement which pull out the area letters, no matter what is in the field. so if the record has a decimal place, it would return either a decimal place or nothing.

Thanks for your help.