Yah... forgot that the NTEXT data type is being used... sorry.

Of course it's only creating one file... that's because you hardcoded the output file name as c:\Person_notes.txt.

You need to make the file name dynamic, as well.  Perhaps using the...

John,

Understood... I just don't make those same assumptions... if the requester knew about those types of things, they might not have needed to ask the original question

If the columns a VARCHAR or the like, you can use SOUNDEX (won't work on numbers).

It's not SQLAgent that you need to be concerned with... it's the security setting on the server itself... WHO is the SQL Server SERVICE logging in as?  If it's not...

What's wrong with LEFT(somentextval,100) ???

I absolutely agree with using a tally table as Remi and Sreejith have... I just can't bring myself to create a tool that helps avoid cursors and loops by using...

Yes... instead of using the "-o somefilename" parameter, use the DOS "redirect as append" characters ">> somefilename".

Sorry Vandy... I just can't read minds today... what's not right about the total sum?

Vandy... how about telling us which columns the +ive and =ive numbers are stored in?  If they are both in the InvoicedValue column, then Marino's should have done the trick...

Better make sure you do a backup before you truncate the log or you won't be able to recover to a point in time which is the purpose of Full...

Sure... what's the Primary Key of the person table?

Maybe this weekend... right now, I'm still sucking my thumb wonder what the heck I was thinking

I'll say... as for me, I can't find the examples I had made for something else (might not even be the same problem ...

Outstanding... thank you for the feedback.