In Toad Data Point, working with SQL Server, after a query was executed, in the data grid, there was a column with data showing extra spaces ( right padded with blanks ). See image below:
If the value provided to a variable of CHAR data type is shorter than the length of the declared column size, then the value would be right-padded with blanks to match the size of column length.
RESOLUTION:
In order to delete the extra space, this query can help:
Also, keep in mind: Working with Varchar will avoid to create the extra space at the end. But if the extra space was already generated, run this query (the one above), will fix the situation.
© 2022 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy