Problem with trim query

[Manolo]

Hello,
I have to work with an old database that uses CHAR and TEXT fields. I need to remove the ending blank spaces of those fields so I have tried with RTRIM() but it is not allowed for TEXT fields. After that I tried with RTRIM(Convert(NVARCHAR(max),"column")) and it does the job, but it always sets the AllowDBNull column property to TRUE.

Is there an easy way to acomplish this? What can I do?

[Pinturiccio]

You can perform a script, trimming trailing spaces for each string in the database. After this you will not need to trim strings in each query.

We will also investigate the possibility to add a property that will enable trimming all the data when fetching them and post here about the results as soon as possible.