I advise against using those values for primary keys. Use an Identity field instead and store the imported values in an indexed column.
>Hi, is ther any restriction or best practices on using '' "" on primary keys or codes? we are about to import some data to a sql server database, these codes and / or descriptions have '' or "" on them and i am concern about the behavior of the system when querying data
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer