Hey guys

my field is set up in sql as char 100

although when i pass in a string of say 10 charcters, this is stored in the field as 10 characters followed by 90 spaces, does anyone know why this is??

I suppose a way of fixing it is by using TRIM but surely there must be an option to sotp this form happening???