>Hi Larry
>
>>This has got me bugged.
>>I have searched high and low and I can't find any reference to query performance being hindered using varchar vs. char.
>
>I think we may be talking at cross purposes. The original question was in relation to Primary Keys, not query performance.
>
I may have been reading too much into it. My take on the original message was more in line with JOINS (since he used the term foreign key) and how those were affected.
IAC, it was good to have this chat. ;-)
Later.
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao