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 🙂

Spelling 😀

It might be able to write to you

It can probably string a better sentence together than the average DM 'journalist' already.

create table #PostCodes

(

PostCode varchar(15)

)

insert into #Postcodes values

('AA1 &&%((£4GG')

,('AB2 **%%6TG')

,('£FE2 %5GH')

,('BL0 9QT')

select

Postcode

,cpc.pcode

from #postcodes

cross apply

(

SELECT Pcode = (SELECT SUBSTRING(Postcode,N,1)

FROM (VALUES (1),(2),(3),(4),(5),(6),(7),(8),(9),(10),(11),(12),(13),(14),(15)) AS x(N)

WHERE N<=LEN(Postcode)

...