• CELKO (11/25/2012)


    ...

    CAST(@abc AS VARCHAR(10)) should work and it much preferred over the old 1970's Sybase CONVERT string function...

    CAST and CONVERT are similar but not the same. CAST in T-SQL offers limited (basic) data conversion functionality. I cannot see why someone would prefer one over another... It's not matter of preference, it is matter of suitability. Where CAST functionality is sufficient, you use CAST, where it's not enough (requires specific format key/switch) - use CONVERT.

    For example, (especially for standards-loving J.C.) using CAST you can not explicitly convert DATETIME into string in ISO format...

    _____________________________________________
    "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]