There's not in SQL 2000, So just set it to VarChar(100), varchars won't store whitespace so it's not a biggy, although it's best to keep it to a minimum for indexing.
If you're int SQL 2005 then there's VarChar(max)
Char fields store whitespace, no idea what the point of them is, I'm guessing they might be slightly faster for some things, but never really looked into it.
If you're int SQL 2005 then there's VarChar(max)
Char fields store whitespace, no idea what the point of them is, I'm guessing they might be slightly faster for some things, but never really looked into it.