Hello everybody
I'm working with a database and trying to add data to the database with the next stameny:
INSERT INTO table VALUES ('value1')
but the result of doing this, even with the Management studio, is the value value1 with one space at the end. It is like 'value1 '
Any clue?
Thank you very much and greetings from spain.
Santiago
Hi,
Most likely your field declared as CHAR(7), not VARCHAR(7). Length of your string is 6 characters and for the CHAR types SQL Server fills rest of the string with the spaces. This is by-design. If you need a value without spaces, then you would need to use VARCHAR type for this field
|||Thank you very much for the help, problem solved.