this is my first time posting here and I am a basic SQL user and need help. 

I have a `varchar` column that stores data like below:

```
Year.Docid
2007.000000001
2007.000000002
2007.000000003
2007.000000004
2007.000000005
2007.000000006

```

I need to join this data to another table that does not have all the zeros after the decimal, can someone please show me how to get the data to look like below:

```
Year Docid
2007.1
2007.2
2007.3
2007.4
2007.5
2007.6

```

I am using MICROSOFT SQL SERVER 2012