Hi david
I understand completely after looking into this in further yesterday but at present have a major deadline approching for the end of the month, however I will use placeholders from now on with my sql queries and as soon as this deadline has been met I will go back and correct this issue with my current queries but I will have somewhere between 75-100 queries to change this way.
Thankyou for all your help on this matter I really appreciate this and hope I can offer good advice back to others in return.
Thanks
Scott