These are just just...the REAL tables are much larger and more columns in result set...I just want to get the small test join working before working with the BIG tables...

table...

Sorry, I posted to the WRONG forum...

Thanks...I wasn't able to make it fail, it had no problems with the '-' dash as a VALID varchar value...I will send this one back to the developers to take...

Thanks for the prompt reply but here are the datatypes of the composite PK...so, the TOTAL size of the PK is 20 + characters...

delivery_number varchar(10)

delivery_date   smalldatetime

delivery_area    varchar(10)

you are saying that...