If the words in your string are separated by spaces then you can use charindex (as Pam suggested)..like this:

DECLARE @String1 VarChar(20)
DECLARE @String2 VarChar(20)
SET @String1 = 'OneWord'
SET @String2 = 'Two...

Oh I agree..I'm obsessive compulsive to the point of sickness too..I had a co-worker who (to his credit tried really hard) couldn't for the life of him be consistent with...

Sure..but I was addressing CK's.."you HAVE to use column aliasing, whether you use the AS keyword, or not. The AS keyword is optional - but you do have to provide...

sorry - I am in a disagreeable mood today..

select au_id, au_lname, au_fname
into #AS_Discussion
from dbo.authors

select * from #AS_Discussion

drop table #AS_Discussion

..unless there's still something I...

Not sure what you mean...

if it is "select col1 NewCol1, col2 NewCol2 into #temp from myTable" then again there is no error on omitting...

this is completely untried & untested so you need to "play around with it"...

select * from myTable where right(name, 4) = 'mcxl' and col like replicate('[^0-9-]', datalength(col) - charindex(col,...

My one (& only) experience with classes was so abysmal that I'd sworn off ever taking one again...but that was before the new training centre in FL!

I believe it was Sean (McCown) who wrote a neat article on using char(39) for single quotes (search this site)...

based on that you could do a ...

select char(39) + char(44)...

Have you tried using a subquery instead ?!

In all probability your 2nd machine isn't compatible with the t-sql extension - there is a compliance testing level called "fips_flagger" (check it...

Well - I will certainly wish you luck for I think you could use all that you can get..

so you'd have to sort first...

read mkeast's first suggestion..

Maybe there's more to worry about than mere iJacking...read snippets below and rejoice everytime you walk out of Starbucks with your skin intact...

"An afternoon...

a mystery that shall remain unsolved until Vandy makes a comeback..

cross-post...follow link here!

Great catch...maybe a link to the most read article on dynamic sql should be posted here.

btw..@dept_id is not being used!

ps:we used...