For SQL Server 2012 onwards simplest solution is to use TRY_PARSE.

DECLARE @NegativeNumeric varchar(100);

SET @NegativeNumeric='50.10-';

SELECT "Value" = TRY_PARSE(@NegativeNumeric AS DECIMAL(10,2));

Thanks Paul...I'll have a look at your links to see if it can

shed any light on a solution.

Hi Jeff

Thanks for the reply. I think my problem is a bit different

than the solution you provided in that the id of the parent

for the child in #tree...