Create string query concat

Question

I have a table set up with the following rows:

Id_numbers             | Name
------------------------------------------------------- 
00001                  | Clara Sujadi 
00002                  | Raj Setamil 
00003                  | Oakley Suherman

I want to concat a value inside variable.

Here is what I've tried:

DECLARE @query      VARCHAR(MAX)
SET @query = 'SELECT CONCAT(Id_numbers, Name, "some-text") FROM table_name'

EXEC @query

this always gives me error:

Invalid column name 'some-text'.

How to create a query concat inside a variable?

Tag your question with the database you are using.

Gordon Linoff
– Gordon Linoff

2020-06-09 01:17:06 +00:00
Commented Jun 9, 2020 at 1:17 — Gordon Linoff
– Gordon Linoff, Commented Jun 9, 2020 at 1:17

Gordon Linoff · Accepted Answer · 2020-06-09 01:16:53Z

1

The correct delimiter for a string in SQL uses single quotes. You can double them to include them in a string:

DECLARE @query VARCHAR(MAX);
SET @query = 'SELECT CONCAT(Id_numbers, Name, ''some-text'') FROM table_name'

EXEC @query

answered Jun 9, 2020 at 1:16

Gordon Linoff

1.3m62 gold badges705 silver badges857 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Create string query concat

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related