Add inf a currency symbol to a calculated column

• charliedurnin@gmail.com

  SSC Enthusiast

  Points: 120

  More actions

  February 28, 2024 at 6:05 pm

  #4386571

  The question is in the title. The code is

  SELECT SalesLT.Product.Name

  ,SalesLT.Product.Color

  ,SalesLT.Product.StandardCost

  ,SalesLT.Product.ListPrice

  ,SalesLT.Product.ListPrice - SalesLT.Product.StandardCost AS Profit

  ,SalesLT.ProductModel.Name AS SubCatNameType

  ,SalesLT.Product.ListPrice

  ,SalesLT.Product.Name AS SubCatName

  FROM SalesLT.Product INNER JOIN

  SalesLT.ProductModel ON SalesLT.ProductModel.ProductModelID = SalesLT.ProductModel.ProductModelID

   

  Many thanks

• Grant Fritchey

  SSC Guru

  Points: 398694

  More actions

  February 29, 2024 at 2:30 pm

  #4387100

  So, formatting? Personally, I'd recommend doing that on the front-end. Databases aren't the greatest at formatting.

  "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
  - Theodore Roosevelt

  Author of:
  SQL Server Execution Plans
  SQL Server Query Performance Tuning