• Actually after rereading my code, it does NOT examine TEXT data and give a more appropriate data type.

    Only suggest similar data types for text. I.e. Text to ==>> char, nchar, varchar or nvarchar.



    For better, quicker answers on T-SQL questions, read Jeff Moden's suggestions.[/url]

    "Million-to-one chances crop up nine times out of ten." ― Terry Pratchett, Mort