Return
-
Title
Getting an extra space at the end of the record in Toad -
Description
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:
-
Cause
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
RESOLUTION:
In order to delete the extra space, this query can help:
UPDATETABLE NAMESETCOLUMN NAME = LTRIM(RTRIM(COLUMN NAME))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.
-
Additional Information
Note: If SET ANSI_PADDING is OFF when CREATE TABLE or ALTER TABLE is executed, a CHAR column defined as NULL is considered as VARCHAR.