How To use variable in sql like statement

Question

Here is my sql statement

SELECT m.id 
FROM (SELECT id, plu FROM product) t 
   join position m ON m.plu_id LIKE '%' + @t.plu

but got such error operator does not exist: @ character varying

This answer did not help

What is this variable? Where is @t declared? What is it? What is @t.plu? — underscore_d
– underscore_d, Commented Oct 23, 2020 at 10:42
The string concatenation operator in SQL is ||. The + is to add numbers. And @ is invalid in an identifier in SQL as well. — user330315
– user330315, Commented Oct 23, 2020 at 10:49
Unrelated to your question, but: the sub-select is completely useless. You can simplify that to select .. from product t join position m ... — user330315
– user330315, Commented Oct 23, 2020 at 10:50
@underscore_d - I want to compare plu from position and plu from product — Headmaster
– Headmaster, Commented Oct 23, 2020 at 10:52
@a_horse_with_no_name - thanks, your comment helped. You can post an answer and I will accept it — Headmaster
– Headmaster, Commented Oct 23, 2020 at 10:55

Gordon Linoff · Accepted Answer · 2020-10-23 11:12:56Z

1

The + operator in Postgres -- and in SQL in general -- is addition of numbers. That SQL Server extends this definition to include string concatenation is bespoke syntax for that database (and Sybase).

Use the correct candidate operator:

ON m.plu_id LIKE '%@' || t.plu

I assume that the @ is really a constant character that should be part of the pattern.

answered Oct 23, 2020 at 11:12

Gordon Linoff

1.3m62 gold badges706 silver badges857 bronze badges

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

Collectives™ on Stack Overflow

How To use variable in sql like statement

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related