tag:blogger.com,1999:blog-18371456.post3576923910898362799..comments2024-03-26T00:07:20.400-05:00Comments on The Db2 Portal Blog: Escaping Single Quotes in Db2 SQL StatementsCraig S. Mullinshttp://www.blogger.com/profile/17077237739217901780noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-18371456.post-42300042416198121662023-04-06T11:27:49.252-05:002023-04-06T11:27:49.252-05:00LOL... technically, that would only be correct one...LOL... technically, that would only be correct one day each year!Craig S. Mullinshttps://www.blogger.com/profile/17077237739217901780noreply@blogger.comtag:blogger.com,1999:blog-18371456.post-90393991338592708342023-04-06T11:12:00.417-05:002023-04-06T11:12:00.417-05:00Good to know! This is what I've been doing. ...Good to know! This is what I've been doing. <br /><br /> SELECT 'TODAY IS CRAIG' CONCAT <br /> X'7D' CONCAT <br /> 'S BIRTHDAY ! ' AS STRING <br /> FROM SYSIBM.SYSDUMMY1 <br /> ; <br />---------+---------+---------+---------<br />STRING <br />---------+---------+---------+---------<br />TODAY IS CRAIG'S BIRTHDAY ! <br />DSNE610I NUMBER OF ROWS DISPLAYED IS 1 Chuck Kosinnoreply@blogger.com