Question2Replies64Views ABHISHEKSINHA Member since 2013 10 posts HSBC Posted: 2 years agoLast activity: 1 year 7 months ago Closed Unable to update PYLASTUPDATEDATE of pr_extract_time table through Connect-SQLGetting invalid character error while updating the pr_extract_time column PYLASTUPDATEDATE. Below are the post-sql query.SQL Query : UPDATE CDS.pr_extract_time SET PYLASTUPDATEDATE = '02-MAY-18' WHERE PYINSNAME like '%BIX_COAST_AGN%'; commit;Note : The above query is runs fine in SQL developer but throwing error in Connect-SQL.×Close popoverFacebookTwitterLinkedinEmail Copy Link Copied! Moderation Team has archived post This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question. Posted: 2 years agochous PEGA replied to ABHISHEKSINHAHi, Please try using double quotes instead of single quote. This might solve the issue. Thanks Posted: 1 year agolakshmisravanyac7719 Areteans Technologies replied to ABHISHEKSINHAHi Abhishek, Can you please post the query that is being formed when you are trying to run the query from Connect-SQL to understand the scenario better. Thanks.