This is already covered in the FAQ section: http://www.vbforums.com/showthread.p...-an-SQL-string