It looks like you have some non numeric data in your column. Maybe this would help:select

*

from

thangela.NpowerNorthern_v1 a

INNER JOIN

(

SELECT

--Columns needed,

CAST( b.MPANCORE AS numeric(17,2) AS MPANCORE

FROM

EPPS.dbo.Customers...

There are several ways to do this. If you are using SQL 2005 or later you might want to look up the ROW_NUMBER function. But, here is one way to...