Field storing non-existant spaces 1

[rickyoswaldiow]

For some reason, a field I've recently created to store a web address is full of spaces as default... I can write a value to the field from VBA such as

http://www.tek-tips.com

but it then stores it with dozens of spaces after the address!

 

[rickyoswaldiow]

Fixed.
I had the field set to char with not null, I simply changed it to nvarchar and put the default value ('')

 

[CaptainD]

The other way to remove the spaces is use "Trim()" when you pull the data. (RTRIM() for MS SQL server)


With Data type Char(10), 10 spaces are allocated for that location.

In the fields you have "AB "

SELECT MyField FROM MyTable returns "AB "

SELECT TRIM(MyField)FROM MyTable returns "AB"