Hard to say without more details, but it's possible you're getting a number for the second argument of RIGHT that's negative, which causes it to fail.

Try this:

SELECT (LEN(LTRIM(RTRIM([address]))) - LEN(LTRIM(RTRIM((strtype)))))

FROM...

Grant Fritchey (5/23/2014)

---

BWFC (5/23/2014)

---

Does anybody else feel a bit frustrated when there is no response from the OP after you post an answer to a question? I know that...

djackson 22568 (5/19/2014)

---

hisakimatama (5/16/2014)

---

Hrm. Well, it's still rather early in my career (just under four years of being a DBA/Database programmer so far), but I'd say I've definitely failed...

It's because you're not qualifying where the column is coming from in your IN clause; if you don't qualify the column, and it doesn't exist in the table in the...

Hrm. Well, it's still rather early in my career (just under four years of being a DBA/Database programmer so far), but I'd say I've definitely failed so far, on...

Actually, I was already considering doing some index consolidation since you mentioned it in your last post, Jeff :-). Scripted out all of the indexes, and ran some tests.

I...

Alright, back in the office today, so I'm attaching two query plans here.

The first one is for a query like so:

SELECT Name FROM VoxcoSystem.dbo.tblObjects

WHERE ParentId = 137402

It pulls all workers...

Thanks for the reply, Jeff!

I promptly nixed the code in the original post and tossed it into a text file; sorry about that! I didn't realize the IFCode window...

Thanks for the interest in the problem, Gail!

The table has about 160,000 rows right now; the number of rows will vary on any given day, as they're added and deleted...

WayneS (5/7/2014)

---

hisakimatama (5/7/2014)

---

SQLRNNR (5/6/2014)

---

hisakimatama (5/6/2014)

---

SQLRNNR (5/6/2014)

---

hisakimatama (5/1/2014)

---

Whew, busy times at work lately. I've been out of The Thread for a good bit :-).

Anyone else from The Thread planning to...

Ugh. I've had nothing but bad management so far in my career. My current manager is quite the piece of work :-P. Everyone pretty much says that,...

SQLRNNR (5/6/2014)

---

hisakimatama (5/6/2014)

---

SQLRNNR (5/6/2014)

---

hisakimatama (5/1/2014)

---

Whew, busy times at work lately. I've been out of The Thread for a good bit :-).

Anyone else from The Thread planning to attend this...

SQLRNNR (5/6/2014)

---

hisakimatama (5/1/2014)

---

Whew, busy times at work lately. I've been out of The Thread for a good bit :-).

Anyone else from The Thread planning to attend this week's SQL...

Whew! Alright, posting my findings back as I stated earlier, just a good while later :-D. I went to SQL Saturday Atlanta just this last weekend, and saw...

Oh, definitely! I'd be honored to speak with you :-). Atlanta's awfully busy itself, but it's kinda close to where I grew up, so it's great to have...