I am using a SQL 2000 DB with my site created with ASP on UD4. On one form I am calling values from the database into dynamic text fields but it seems that the field value is appended by blank spaces to the max characters. Anyone know why this is and how to remedy it?

Thanks

Mike

Try changing the Data Type from Char to VarChar.

Regards

Owen.

Multiple Parameter UD4 / Access 2000 Database Search Tutorial:
www.tdsf.co.uk/tdsfdemo

Depending on the type of database software you have. I am not familar with the one you referenced. But the data type in the table may be set to char or text and set to some length. If the length is 254 and you use 10, some software will append the remaining with blank spaces. This can also happen on the programming side.... the use of varchar or variable character does not append the remaing size with blank spaces.



Wm. Kent Steelman