>Hello,
>
>We have table which size is 6GB. There is one text field, which is biggest
>in this table.
>We replaced contents of this field
>(fieldvalue = SUBSTRING(fieldvalue, 1, 1)) for half of table's records.
>But size remains the same! Why?!
>
>Giedrius
If the field is declared as Char(x), the database will contain x characters even if they are empty. If the field is declared VarChar(x), it will contain only the required number of characters (plus some overhead I think to keep the length of the string but I'm no sure of that).
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com