Forum Replies Created

Viewing post 1 (of 2 total)

  • RE: concatenate numeric and varchar

    maybe my subject is wrong. i already do a concatenation in this statement

    'RM' + (CAST(CAST(SUM(SLDXX_InvoiceDetail.UnitPrice * SLDXX_InvoiceDetail.Qty) AS NUMERIC(9,2)) AS VARCHAR(10)))

    below is the output from the code

    ProductGroupName Quantity Amount

    Media...

Viewing post 1 (of 2 total)