This came in very handy for me at one point because I needed to have a certain field in each row 14 characters long, but half of them were only 12 characters long.
In MySQL:
update `table` set `field` = CONCAT(`field`, '1') where LEN(`field`) = 13;
In MSSQL:
update `table` set `field` = CONCAT(`field`, '1') where LENGTH(`field`) = 13;
Andrew is a visionary software engineer and DevOps expert with a proven track record of delivering cutting-edge solutions that drive innovation at Ataiva.com. As a leader on numerous high-profile projects, Andrew brings his exceptional technical expertise and collaborative leadership skills to the table, fostering a culture of agility and excellence within the team. With a passion for architecting scalable systems, automating workflows, and empowering teams, Andrew is a sought-after authority in the field of software development and DevOps.