I have a very small question 

I have a table co\_fields which has a varchar column templateid which is all numbers in it, 

if I try 

```
select templateid, templateid + 500 
from co_fields

```

it works fine but I got lot of duplicate records , how can I remove the duplicate records :

current result after running the query is:

```
tempateid   | templateid+500
1000             1500
1000             1500
1000             1500
1000             1500
2000             2500
2000             2500

```

expected result:

```
templateid  | templateid+500
1000              1500
2000              2500

```

thanks