Sure no probs.
char() is a fixed length stirng. If you declare a variable : Declare @MyChar char(5); you may set it equal to any ASCII string that contains 5 or fewer characters. However, if you store fewer than 5, it will still occupy 5 bytes. Varchar is a variable length Data Type. If you : Declare @MyVarChar varchar(5); and then insert 2 characters into it, it will occupy only 2 bytes. BTW, same difference between nchar() and nvarchar().