How to retain Currency formatting in the concatenated the column

How to retain Currency formatting in the concatenated the column

Hi Support Team,

  I would like to keep the Thousand Separator for the " Refund Amt" column.
  This " Refund Amt" column has been concatenated with the "Bill no" Column.
  The Table is generated via SQL Query.

  SELECT DISTINCT (VC."Vendor Credit Number") as "Vendor Credit Number",
   B."Bill Number" as "Bill Number",
   VCR."Amount (FCY)" as "Refund Amount",
   CONCAT(('INR ' + NCHAR(8377) + ' ' + CONVERT(VARCHAR (30), VCR."Amount (FCY)")), '  - ', B."Bill Number")
   as "Refund Amt"
FROM  "Vendor Credits" AS  VC
LEFT JOIN "Vendors" AS  V ON VC."Vendor ID"  = V."Vendor ID" 
LEFT JOIN "Vendor Credits Bill" AS  VCB ON VC."Vendor Credit ID"  = VCB."Vendor Credit ID" 
LEFT JOIN "Bills" AS  B ON VCB."Bill ID"  = B."Bill ID" 
LEFT JOIN "Vendor Credit Refunds" AS  VCR ON VC."Vendor Credit ID"  = VCR."Vendor Credit ID" 
LEFT JOIN "FIND TABLE" AS  FT ON FT."B.Bill ID"  = VCB."Bill ID"
AND FT."VC.Vendor Credit ID"  = VCB."Vendor Credit ID"  

  




Kindly help me retain the currency formatting  of the Thousand separator  and " INR" in the concatenated column - Refund_amt (Col no. 3)