• Then VARCHAR. Give it some relevant size based on sample of data you have. It looks like extract from other system, so you may ask for specification describing maximum length for this field...

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]