Jim,

Out of the box SQL 2005

declare @myTab table( ExtRef varchar(9), IntRef decimal(38,19))

insert into @myTab(ExtRef,IntRef) values ('$1.00',0)

insert into @myTab(ExtRef,IntRef) values ('2.1',0)

insert into @myTab(ExtRef,IntRef) values ('A',0)

update @myTab

set IntRef = case when isnumeric(ExtRef) = 1 then cast(ExtRef as decimal(38,19))else cast(-1 as decimal(38,19))

--(A)

end

Good catch on the dollar sign!