• Yeah, the equivalent data type will be a numeric on SQL Server, but his destination is an integer. I've seen systems that used large numeric data types, but only stored whole numbers in them so converting to integer was a possibility. If not, the destination types should be changed or you'll have to face losing precision with the numbers.

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden