I don't know what your data looks like but that will only work for an eight character postcode. If you take the rightmost eight characters of your string you will...

SELECT

ltrim(right(postalcode,charindex(' ',reverse(postalcode),PATINDEX('% %',reverse(postalcode))+1)))

FROM yourdata

I've tested this over 14500 county+[space]+postcode combinations and the only ones it didn't work on were cases where there was no space in the...

Postcodes can be 6,7 or 8...

Pack_Star (9/8/2015)

---

Hi,

Most of the records in this column are correct i.e. NN4 0NB (two strings separated with a space), Then occasionally I return corrupt records i.e. Derbyshire S42 5BX (three...

I suspect that's got something to do with how people have researched this....

Reported as spam

Alvin Ramard (8/3/2015)

---

Ed Wagner (8/3/2015)

---

Sean Lange (8/3/2015)

---

Again lots of complaining. Come on people get over it. The question of the day is intended to provoke some learning. Guess what, as...

Sean Lange (8/3/2015)

---

Again lots of complaining. Come on people get over it. The question of the day is intended to provoke some learning. Guess what, as humans we learn more...

TomThomson (8/3/2015)

---

Anyone who says "this is the most badly put together question I've seen for a long time" has clearly not looked at many Questions of the Day, and the...

Reported as spam.

Not only do none of the answers appear to be correct but the the explanation does not match the options.

The correct answer is Query 2, with the MODIFY FILE option...

Have you thought about using <= and >=?

SQLRNNR (7/27/2015)

---

Toreador (7/27/2015)

---

SQLRNNR (7/25/2015)

---

Well, if the view does not exist or is in a different schema, then the third option is correct even though it truncated part of the error....

Phil Parkin (7/27/2015)

---

Brandie Tarvin (7/27/2015)

---

TomThomson (7/26/2015)

---

Don't get caught...

It's home made quesadillas here. There may well be room for tequila 🙂