Data's are not a problem because this query ran when i transferred the this single column data's to another table.

but error came on the original table only.

both column data types are same

-- This Query Runs Successfully this Table has only one column.

Select LHP.LHP_PARAM_RESULT_VALUE,

Cast(Replace(LHP.LHP_PARAM_RESULT_VALUE,',','') as decimal(18,2))

from LS_HMT_PARAM_RESULTS_TEST LHP

Where

ISNUMERIC(LHP_PARAM_RESULT_VALUE) = 1 AND

LHP_PARAM_RESULT_VALUE <> ''

-- This Query has error with various record counts at various running

Select LHP.LHP_PARAM_RESULT_VALUE,

Cast(Replace(LHP.LHP_PARAM_RESULT_VALUE,',','') as decimal(18,2))

from LS_HMT_PARAM_RESULTS LHP

Where

ISNUMERIC(LHP_PARAM_RESULT_VALUE) = 1 AND

LHP_PARAM_RESULT_VALUE <> ''