jwcolby
jwcolby at colbyconsulting.com
Wed Mar 19 18:28:50 CDT 2008
I have another (different) database from hell. This one has data fields like HOUSENUMBER StreetName StreetUnit 00000006 000012th Place As you can see, if I do a simple append, then I get something like 00000006 000012th Place. I can tell you that won't fly. So I need to strip off leading zeros, pretty much in ALL my fields, but at the very least in a fixed set of fields. How do I do this in SQL, bearing in mind that this table has 90 million records and taking a week for one field is out of the question. John W. Colby Colby Consulting www.ColbyConsulting.com