The following returns any record with the carriage return character in the accountid field of table accounts. (db2)
select *
from accounts
where accountid like '%' || char(x'0D') || '%'
Search This Blog
Code snippets and memory joggers
Subscribe to:
Post Comments (Atom)
About Me
- Keith
- I love to travel and meet new people, motorbikes, moving my body through dance, martial arts and yoga. I'm a lifelong learner interested in how things work, and the way people think and make their decisions. My choice of superpower would be to speak with someone and understand them completely, including their intention and for me to be able to communicate my intention to them clearly in their own language. As an Amazon Associate, I may earn from links to qualifying purchases.
No comments:
Post a Comment