You can use PATINDEX or CHARINDEX to do that.

It was so easy it took at least 20 minutes research to make sure there wasn't a catch. I must have checked half the documentation and writing about page...

Dinghy

I got it wrong because I misinterpreted this line:

When you specify a PRIMARY KEY constraint for a table, the Database Engine enforces data uniqueness by creating a unique index...

Venus

Andy Warren (7/10/2014)

---

BWFC, I can tell you it's been a lot of fun writing them. Not all go well and I learn, and try to remember to listen and not...

Thanks for your reply Andy. I can imagine how difficult it is to create a question from an interesting situation and make it answerable without giving too much away....

Edit because I missed the obvious problem.

This does require you to make the assumption that FileID is probably a numeric of some type, in real life you'd probably get...

Required

solomon.jernas (7/9/2014)

---

we have 7TB database is running sql 2000 ,so need to migrate 2005 , as they requested 30 min time enough for migration this db...

you said , impossible...

End

After weeks of wrangling and negotiation the company has finally splashed out and agreed that I can have the course that I originally requested. Although I can't, because I...

Iulian -207023 (7/7/2014)

---

I'm sure I'm missing something very basic here but I was under the impression that because there is no ordering automatically on a table, the row returned by...

I'm sure I'm missing something very basic here but I was under the impression that because there is no ordering automatically on a table, the row returned by TOP n...