Run query that concatenates parameters (@p) in Firebird

Question

I need to run a query where the value to be concatenated must be passed as a parameter for the query.

SELECT t.id || @p || t.nome FROM Test t;

But when executing this query it returns the following error: Dynamic SQL Error.

In Mysql this same idea works as follows:

SELECT CONCAT(t.id, @p, t.nome) FROM Test t; 

I wonder if there is any way to do this kind of concatenation in Firebird? Because from what I understood the operator || is what causes this problem when a parameter is used.

Obs¹: It is necessary that the value to be concatenated as separator is passed by parameter.

Obs²: I know that if I concatenate the value in the query it works, the query will be executed this way: select t.id || 'stringparaseparar' || t.nome from Test t;, but in my case as mentioned above it is necessary that this value is passed by parameter. Ex: set @p = 'stringparaseparar'.

To clarify better the reason for this need follow that other issue that describes the origin of this problem.

Answer 1

In this case you should make one cast of the parameter to sweep:

SELECT t.id || cast(:p as varchar(10)) || t.nome FROM Test t;

Answer 2

for you to test this in IBEXPERT or even use inside your application Voce has to do a query of a Soted Procedure Voce has to pass to a STORED PROCEDURE

Your Select Origin Command of a precedent looks like this:

Select cidade From Busca_CEP("17504110")

---

create or alter procedure BUSCA_CEP (
    PCEP integer)
returns (
    cidade varchar(60)))
as
begin
   Select CEP.cidade From CEP into :cidade;
end

I think that solves your problem...

Answer 3

You should do it like this:

SELECT t.id || :p || t.nome FROM Test t;

and not:

SELECT t.id || @p || t.nome FROM Test t;

Answer 4

I’m not sure I fully understand your question, but come on.

Table: Product

Code | Name | Complement 1 | Pencil | Black 2 | Pen| Blue

 Select Codigo, Nome, Complemento,  Nome|| ' COR' || Complemento as TudoJunto from Produto

Upshot:

1 | Pencil | Black | Lapis COLOR Black

2 | Pen| Blue | Pen COLOR Blue

Otherwise, post a comment that I edit here.