long time = 120 minutes +

I do not have any indexes on the destination table, this is a straight import from a flat file with a specified column delimeter.

Thanks, I have learned something new today

Thanks SSC-Enthusiastic

this worked for me, I forgot to mentioned that some values be negative, but this works

DECLARE @l_CharVal VARCHAR(20)

SET @l_CharVal = ' 50.12- '

SELECT

...

Thanks SSC-Enthusiastic

I forgot to mention that some values do not have a negative at the end, but your code worked.

Thanks again for all the replies.

thanks, will try it