HERESY!

The Thread controls all.

Great is The Thread.

Mighty, mighty is the Thread

To be licensed to practice law in Florida, I had to pass the state bar exam... and don't think there aren't cram courses and outlines for that. ...

Lynn, I assume it would be unhelpful for me to join that discussion and suggest indentured servitude?

Hey Matt... I just got some new glasses.

Is your avatar the Master Control Program from "Tron" ??

Kingston, that's why I added the footnote.

I considered posting a tally table solution, too, but that was probably overkill. 😛

Good job! Glad its working for you now.

Paul, you are compelling me to up my game here in the forums. You will be hearing from my wife about the lack of attention she receives while...

I can't disagree with this statement, and yet I feel it is incomplete. While optimum performance is always a goal, sometimes the...

Hey, I've got a couple free hours a week, Math skills...

How about ?

select ....

from...

WHERE NAME LIKE isnull(@NAME,'')+'%'

Also, how about showing us the name you are trying to search, and the string that is in the @name variable. ...

No, no, Wayne.... that's just what they'll be expecting him to try!!

I might have said the following because it's more performant than a RIGHT() function.

REVERSE(LEFT(REVERSE(LTRIM(RTRIM(colname)),10))

Please note: People without...

Howsabout I email yousa right now?

Barry.... how do we know He didn't just do that?

Don't answer that.... I may do my next article on P=NP. The Clay Institute pays better than SSC.

Not quite sure what you mean by that. Can you draw us...

RBarryYoung (3/25/2010)

GilaMonster (3/25/2010)

From what I recall, it's...