sql server - SQL Better performance: char(10) and trim or varchar(10) - Stack Overflow
@KM: a char column compare with a varchar literal will convert the column to varchar (datatype precedence). Then you'll need to TRIM it. Or CAST the literal to char. Whatever, it's simpler just to use varchar to keep code simpler – gbn Apr 16 '10 at 4:49...