Incorrect Data in Grp

Ramco Ramco

3y822SQL

In below query it is showing like below

Group 5A 2

SELECT [GroupName],
    CASE
    WHEN GroupID = 2 THEN
      CONCAT('', [GroupID], '')
  END AS Grp
FROM
  [[Group]

Thanks

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Cr Bhargavi3y ago
Hi Ramco, Please use htmlspecialchars for the safe data and loop through results, applying formatting within table cells. It will help you with the delivering the SQL indivually so that you would be able to get the appropriate results
0
Saravanan Ganesan3y ago
The provided SQL query uses a CASE statement to format specific GroupID values with red and bold styling. To safely display this, fetch results using your preferred programming language, like PHP. Use htmlspecialchars for data safety and loop through results, applying formatting within table cells. Ensure to manage HTML rendering separately from SQL for security and organization.
+1

Tahir Ansari3y ago

SELECT
    [GroupName],
    CASE
        WHEN [GroupID] = 2 THEN
            CONCAT('', CAST([GroupID] AS NVARCHAR), '')
    END AS Grp
FROM
    [Group];