Is it OK(efficient) to use a smalldate as a primary key? Dates seem to be avoided. My data is very date oriented. I would like to have use of the built-in date functions. The method I often see is the date being stored as a character string. Can you recommend any resources that deal with this topic. Many thanks,