A SQL Trick to Eliminate Unwanted Spaces

Data integrity can be a vexing, but there are some data integrity issues that can be cleaned up using a touch of crafty SQL. Consider the common data entry problem of extra spaces in a name field. Not only is it annoying, sometimes it can cause the system to ignore relationships between data elements.

Read this article...

Craig Mullins

Craig S. Mullins is a data management strategist, researcher and consultant. He is president and principal consultant of Mullins Consulting, Inc., and has nearly three decades of experience in all facets of database systems development.

Craig has worked with mainframe DB2 since V1 and has experience with several other DBMS products, including SQL Server, Sybase and IMS. You may know Craig from his popular books: DB2 Developer's Guide, which has more than 1,500 pages of in-depth technical information on DB2 for z/OS, and Database Administration: The Complete Guide to Practices and Procedures - the industry's only comprehensive guide to heterogeneous database administration.

More information on Craig is available at

comments powered by Disqus