• The only real problem with this approach is that you have a lot of disk access as SQL Server might have to repetitively get the same value over and over again

    If you've got disk access issues for what would be such a small table, then I'm sorry but you've got bigger problems. In reality this sort of table would reside almost permanently in data cache. Thus all requests would happen in memory and not result in disk access.

    Personally, I'd go for the table and/or udf approach before installing an extra item on the server.

    --------------------
    Colt 45 - the original point and click interface