[dba-SQLServer] SQL Nightmares

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

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

More information about the dba-SQLServer mailing list