You're right...however, I should have explained more...it's not my database. I might be able to download it to my machine but its huge, etc. I'm relatively new to SQL (I mostly use MUMPS). I didn't know if there was any type of on-the-fly conversion type function that I could use in the join. I guess worst case I ceate a temp table to play with.