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...
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...
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...