First, I agree with Remi 100% but those darned 3rd party dummies just keep writing junk and selling it.  Worse yet, we keep buying it

I'll probably get a...

The problem isn't that DATEDIFF subtracts years... it's that it counts the number of times the date changes from 12/31 to 01/01.  Subtle difference but very important using other date...

Wasn't that lucky... it's 24/7.  We get to bounce the server once a week for "impacting changes" for about 30 minutes... then, QA get's to verify what we've done.  Of...

Yeah, I wish I didn't need it!  Wonderful 3rd party solution at work.  Bunch o' DB rookies... these are the same wonderful folks that built an Oracle-Like sequence table (NextID)...

Hang on there, Paully21, I'll get to you in a minute...

I absolutely agree with everyone that having CSV columns in a table is a basic form of "death by SQL". ...

LMBO!  Both at the design and your great sense of humor which allows you to calmly handle the mess they've heaped upon you!  I don't know about anyone else, but your...

Dang!  I must be old!  None of the newer online slang dictionaries has SOFH or BSOFH!  Remi, where did you find that definition?

Ok, ok... you got me... I've got dirt in my garden that's younger than I am... As you can tell, though, I've had...

Remi is correct... it takes the original description and wraps it in single spaces.  Basically, it allows this single search ('% myword %') to work on the following descriptions...

something myword...

Ok... but the scenario you just stated exactly fits the methods I suggested... whatever.

To answer your original question, you need to use some Dynamic SQL to do what you want......

Here's a way to avoid the table scan...

select * from task where Descr LIKE '% myword %' OR Descr LIKE 'myword %' OR Descr LIKE '% myword'+char(10)+'%'

If you...

IMHO, archiving data into separate monthly named databases is one of the worst things you could do... they (3rd party provider) did the same thing were I work and it's...

Does this do it for ya?

SELECT 'ID1' AS IDName, ID1 AS IDValue FROM yourtable

UNION ALL

SELECT 'ID2' AS IDName, ID2 AS IDValue FROM yourtable

UNION ALL

SELECT 'ID3' AS IDName, ID3...

I know what you mean... It's only when they live up to the name of "BSOFH" and they've got that control thing going on... or, they're just plain old stupid.

I gotta agree with THAT!  Between a tally table (you guys call it a numbers table) and/or a date table (mine are combined into one which is why I called...