"fourth life"........???????????? you get one from shooting me ??????????

"Self-ridicule is quite fine..."..except that's probably the only time that the less people that are in agreement with you, the better for your morale...

Make...

MattieNH - thank you for pointing out the correction - the only excuse I have in my defense is that the later the hour the fuzzier my brain becomes..

Chris - couple of suggestions - try opening the clipboard by typing in "clipbrd" in the run command window and see if that opens it...?!?!

Alternately (or simultaneously) - if you...

Luke - in remi's defense I should say that he's very seldom condescending - the only time I've seen him really lose his poise is when someone doesn't get "it"...

aah - took the words out of my mouth...maybe stop the sql server agent another option ?!

You can terminate a job via Enterprise Manager - right click on job and select "Stop Job"

The only time I've seen this happen is when the backup file gets "appended" as opposed to "overwritten"...

In your post DelBkUps 1WEEKS seems to indicate that the backup file is...

something very similar has been addressed in this other post

Applause for the CASE statement...

"...also need to include the column..."...My bad..what I meant to say was to concat the variable @Result which you'd left...

Phill - using ISNULL the way you have it only adds a leading comma instead of a trailing one...also need to include the column...

SELECT @Result = txtField + ISNULL(','...

QPR - NO NO NO...Don't let the "CursorsAreEVIL" police catch you saying this (& this site is crawling with them...)

Try & use a stored...

sorry - am in the middle of something - promise to get back in an hour or so!!!

This could be one of the ways to do it...

declare @result varchar(255)
set @result = ''
select txtField from myTable where condition....
if @@rowcount > 1
   begin
   ...

now that you mention it - I do remember thinking..."hmm, hope all's well with remi - his posts seem to have reduced from one a minute to about 1 in...