Right in the middle of the million rows is a record or two that is mangled. Rejecting the file isn't an option. The import routine needs to be able to...

Two way street here... HOW did you resolve it?

Good to be worried about these types of things... try...

Heh... graduates from "Micromanagement 101", I'm afraid... 😉

[font="Courier New"]DECLARE @PostalAddress TABLE (StreetAddressTxt VARCHAR(100))

INSERT INTO @PostalAddress (StreetAddressTxt)

SELECT '123456\78910' UNION ALL

SELECT 'ABCDEFG\HIJKLM'

SELECT * FROM @PostalAddress

UPDATE @PostalAddress

SET StreetAddressTxt = SUBSTRING(...

If you have a small file example (emphasis on "small"), attach it to a post and let's take a crack at it... 😉

Cast to INT will get rid of leading zeros.

Heh...

Step 1... search SysComments for the word "Cursor".

Step 2... search SysComments for the word WHILE

Step 3... search SysComments for the occurance of any view.

Step 4... review all User Defined...

Interesting site with more than what I ever wanted to know... 😀

I did find some files to "play" with...

http://www.census.gov/genealogy/names/names_files.html

I'll ger it a try... thanks.

Gosh... what's wrong with just...

EXEC master.dbo.xp_fixeddrives

Heh... thanks for the feedback, Mark... and no problem...

Say, do you have the URL for that census data? Might be fun to play with... thanks.

Steve,

Heh... this is one of the things on my upcoming wish list... it would be great to be able to control a lookup for posts that have <= X replies...

True... but I'd still try. And, it's not just grammer... using the correct words can mean the difference between someone thinking that...

Heh... stop watch or ...

DECLARE @StartTime DATETIME

SET @StartTime = GETDATE()

--...code to measure duration of goes here...

PRINT CONVERT(CHAR(12),GETDATE()-@StartTime,114) + ' Duration (hh:mi:ss:mmm)'