Incorrect syntax near |

Question

Hi SELECT CASE WHEN GroupID = 2 THEN ' ' || GroupId || ' ' END AS Grp FROM Group Thanks

Jignesh Kumar · Answer

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

Ramco Ramco · Answer

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

Abhishek Yadav · Answer

It is just showing in output - 2

Tasadduq Burney · Answer

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

Ramco Ramco · Answer

Hi Mohammad It is just showing in output - 2 Thanks

Ramco Ramco · Answer

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

Jignesh Kumar · Answer

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

Ramco Ramco · Answer

Hi Bhargavi It is still giving error - Incorrect syntax near | Thanks

Tahir Ansari · Answer

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.

Mohammad Hussain · Answer

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;

Prasad Raveendran · Answer

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.

Ramco Ramco · Answer

Hi Burney It is printing this . It is normal text. Style not getting implemented 2 Thanks

Cr Bhargavi · Answer

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