Post Code / Zip Code Query in SQL Enterprise Manager

[Rawhide]

Use Charindex() to find the position of the space and then use Left() to find everything up to the space.

Select Left(PostCode, CharIndex(' ', PostCode) - 1) As PostCodeArea
From MyTable
Group By Left(PostCode, CharIndex(' ', PostCode) - 1)