create table #t (c varchar(50))
insert #t values('580.00 (Gross)')
insert #t values('1039.99 - customer still owes')

select c, convert(money, substring(c, 1, patindex('%[^0-9.]%', c) - 1)) 
from #t

This page was last updated on May 01, 2006 04:28 PM.