Page 1 of 1

Problem with trim query

Posted: Tue 27 May 2014 12:08
by 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?

Re: Problem with trim query

Posted: Thu 29 May 2014 14:55
by 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.