alternative to TRIM?? help needed.....
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???
Re: alternative to TRIM?? help needed.....
Hi,
If you have set up your database field to reserve spaces for 100 characters then that is what it will do. Why do you object to using the Trim function when obtaining the data from the database?
Re: alternative to TRIM?? help needed.....
use varchar or nvarchar, instead of char, as your datatype in your SQL table and it will not use all 100 spaces
Re: alternative to TRIM?? help needed.....
yea thats it working...
many thanks