Whether I agree with bit-masking in SQL Server or not, I enjoyed the article. Thanks.

I'm looking for a way to check for a view or table and if it is there, do nothing, if it is not there create it. Typically there is the...

Have you actually tried that and gotten it to work?

Besides, if you're gonna take the time to define a table variable, you might just skip that step and...

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.