Hi Noling,   Thanks for your response and the example.    Yes, '#' is used for creating temporary tables while connecting to database. If the syntax error is there, then that will be generated in the log of the program as an error. But, it didn't. The code is working now after inserting 'execute (' and ') by sqlsvr' for each update and delete statements.      Regards, Yashoda Vemula ... View more

Hi Ballard,   Thanks much for the detailed explanation on the steps to identify the boolean and text values, pros of the boolean values and the formatting procedure.    I will format these values and use it in comparison. Appreciate your support.   Regards, Vemula ... View more