Thanks everyone for the valuable feedback. I took bkelly's advice and read the article on dynamic sql and it worked.