Incorrect syntax near |

Using + operator (works for SQL Server, MySQL):

SELECT 
  CASE
    WHEN GroupID = 2 THEN
      '' + CAST(GroupId AS VARCHAR) + ''
  END AS Grp
FROM "Group";

If you provide information about the database you're working with, I can offer a more precise solution.

  It is just showing in output - 2

Hi Jignesh

  It is simply printing like this - 

||2|| . Below is the code

SELECT CASE
  WHEN GroupID = 2 THEN
    ' ||' + CAST(GroupId AS varchar) + '|| '
Else CAST(GroupId AS varchar)
END AS Grp
FROM [VivlioSyn].[dbo].[Group]

Thanks

SELECT CASE
  WHEN GroupID = 2 THEN
    ' ||' CAST(GroupId AS varchar) '|| '
Else CAST(GroupId AS varchar)
END AS Grp
FROM Group

Hi Burney

  It is printing this . It is normal text. Style not getting implemented

2

Thanks

Try this 

SELECT 
  CASE 
    WHEN GroupID = 2 THEN
      '' + CAST(GroupId AS VARCHAR) + ''
  END AS Grp
FROM [Group];

Hi Mohammad

   It is just showing in output - 2

Thanks

Hi Jignesh

  It is still giving same error . GroupId is int

SELECT CASE
  WHEN GroupID = 2 THEN
    '' || GroupId || ''
Else CAST(GroupId AS varchar)

END AS Grp
FROM [Group]
where GroupID = 2

Hello Ramco,

You have missed else part in your query, please check below,

SELECT CASE
  WHEN GroupID = 2 THEN
    '' || GroupId || ''
Else CAST(GroupId AS varchar)  

END AS Grp
FROM Group

Hi Bhargavi

  It is still giving error - Incorrect syntax near |

Thanks

SELECT
  GroupID,
  CASE
    WHEN GroupID = 2 THEN '' || CAST(GroupId AS VARCHAR(10)) || ''
    ELSE CAST(GroupId AS VARCHAR(10))
  END AS FormattedGroup
FROM GroupTable;

Hey Ramco Make sure that you have a column named "GroupID" in your "Group" table, and this query will generate a result column "Grp" with the HTML formatting for rows where GroupID equals 2.

SELECT
  CASE
    WHEN GroupID = 2 THEN
      '' || GroupID || ''
  END AS Grp
FROM Group;

If you are running this query in a database management tool or environment that displays query results as plain text, it won't interpret the HTML tags and instead, you'll see the raw HTML code as output.

Hi Ramco,

SELECT
CASE WHEN GroupID = 2 THEN

'' + GroupID + ''
END AS Grp
FROM Group

*******OR*********

SELECT
    CASE
    WHEN GroupId = 2 THEN
      CONCAT('', GroupId, '')
  END AS Grp
FROM
  Group;