Hi francis I suggest you put the final SQL variable into textbox or clipboard then try to debug the output SQL String . Maybe you miss something like space and ''