Sorry for the post, didn't realize this was SQL 2005

OK

Currently I have it stored as

street_line1 VARCHAR(100)

street_line2 VARCHAR(100)

street_line3 VARCHAR(100)

city VARCHAR(30)

state ...

As a VARCHAR(100)

I'm still having problems.

Do you know a way using either SOUNDEX or DIFFERNCE to get the following results?

I'm wanting to take to addresses (a parent record and a child record),...

I never even thought about using cmdshell.

Thanks Bud!!

Thanks guys.

So just to clarify: It is the collation that makes the sql server case sensitive.  Right?

I just have no idea how to make not be case sensitive.

I know to check/change the database default.  How do you look at the server default?

Worked out GREAT!

Thanks

I appreciate all of the help guys.  I ended up using the following the system stored proc

sp_configure 'remote query timeout', 0

go

reconfigure with override

go

Thanks

Sorry for being so verbose.

This is the following error I keep receiving

Could not process object 'CALL S10142CA.GENPRDCUST.SP9994('         050', '20040815')'. The OLE DB provider 'MSDASQL' indicates that the object has no...

That was one of my first thoughts.  Still didn't work

GOOD JOB!!

I'm glad you got it working

This may seem like a lot, but here it is.

/*********************************************************************************************/

IF (OBJECT_ID('tempdb..#my_table') IS NOT NULL) DROP TABLE #my_table

CREATE TABLE #my_table

 (

  [id]    INTEGER IDENTITY(1,1)

  , start_date  DATETIME

  , end_date  DATETIME

&nbsp

Excellent!

Thanks to both of you for all your help, as well as the scripts.  It's good to have a place for DBA's to help each other.

Shane

Wow!!

Thanks for all the help guys.  My next question is: Which way is better?  A rebuild or a defrag?  Do they both accomplish the same thing?  Should I use both? ...