Fixed and variable field Length

[shajahanvall]

Is there any advantage by setting a filed, fixed or variable length. In my application there are somany deletion and modification of records. Will Fixed/Variable Property affect my programs performance or database size?

[si_the_geek]

Assuming that the data is variable length, a variable length data type is best - it takes less space in the database, and requires less memory/network usage (which could both potentially affect performance).