Hi,

Thank you all so much for the reply.  I really appreciate it.  And thanks Norene for informing me about the RedGate's software.  Looks like I would have to go with that...

Ok I found the solution.  I can't credit for it I found it on another thread.  I just modified the code to fit my...

No not yet, I'll let you know and post it when I find the solution.  Although I don't understand why sql server won't let you assign text datatype as a...

I think you misunderstood me.  It not a file I am trying to store in the database.  It a block of text.  For example, the user would cut and paste...

Thanks for the reply Phill.  Actually the application I am working on is set up to insert a block of text like a resume which could exceed 2k in the...

First off thank you everyone for the responses.  David, thanks for the link to the article. That was a great help.  The procedure returned exactly the results I was looking...