thanks anyway but I'll leave it as it is now and move on. As I said this is all part of a learning curve, and as the old saying goes....

Thanks for the input guys. I have removed the sp's as suggested although this has created alot more code in my app. Still needed to add the extra quotes though.This...