Validating select - interdating ru
One place where you can do that is the Easy Peasy site, where the list is available free of charge.
That won't tell you if the code actually exists, but it will flag up any codes that are not in the correct format. It usually consists of one or two letters, followed by one or two digits.Compared to the outward code, the inward code - the part after the space - is quite simple.It always consists of exactly one digit followed by exactly two letters.The digit indicates the sector; the letters show the unit.The unit within the sector represents a very small area, typically containing just 12 - 15 addresses. But it's really not that bad when you consider that there are only six possible patterns for a valid postcode (see Table 1).Given a postcode column within a SQL Server database, here's a T-SQL query that will check the validity of the codes, based on the syntax rules discussed above.
The query returns all invalid postcodes from the relevant table.
In the case of London, some of the densely-populated central districts are further divided by means of an extra letter at the end of the outward code.
For example, within the SW1 district, SW1A covers Whitehall and the Mall, while SW1E is Victoria Station and nearby streets.
It returns the starting position of the pattern within the string, or zero if the pattern is not found.
In this case, we call PATINDEX() six times per row, once for each of the possible postcode patterns.
There are also a few special-purpose codes that don't follow these rules.