Converting Varchar to Int error
LEN() in most SQL distributions do not include spaces.  You would want to use something like DATALENGTH() for that. 
https://stackoverflow.com/questions/1151693/len-vs-datalength-in-sql-server-2005
As for where the '.' and spaces came from, we would need more information like how is that field being populated?  What app, directly via SQL, etc.
Also, it would be helpful to know what distribution you are using.  I assumed SQL Server.