Ramco Ramco

Ramco Ramco

  • 441
  • 3.4k
  • 506.2k

Incorrect Data in Grp

Aug 15 2023 5:44 AM

Hi

   In below query it is showing like below

Group 5A    <span style="color:red;font-weight:bold">2</span>

SELECT [GroupName],
    CASE
    WHEN GroupID = 2 THEN
      CONCAT('<span style="color:red;font-weight:bold">', [GroupID], '</span>')
  END AS Grp
FROM
  [[Group]

Thanks


Answers (3)