Post reply

Data Type Mismatch when updating with concatenation

  • April 19, 2006 at 11:07 am

    #633110

    If your POX_NAME is of varchar type and UNIT & QTY of int types then convert the 2 columns to varchar first....

    SELECT POX_NAME + SPACE(1) + CAST(POX_UNIT AS VARCHAR) + SPACE(1) + CAST(POX_QTY AS VARCHAR)







    **ASCII stupid question, get a stupid ANSI !!!**

Viewing post 1 (of 2 total)

You must be logged in to reply to this topic. Login to reply