>IMO, if it's always less than 1K, use a varchar column in the table. My reasoning? The smaller the rows, the more rows per data page. The more rows per data page, the better the performance - generally.
>
>-Mike

thanks Mike - we'll probably convert most of our text fields to varchars