Subject in() in firebird
Author checkmail

Hello,

 

I would like to a variable for the in-function

 

Declare str_var varchar(20)

While…

Str_var = str_var || integer

 

(str_var = 4,7,8)

 

Select 1 from rdb$database where (select … where field in (:str_var)

 

Is there a way to realize it? I know, I can use a statement.. execute statement.. but perhaps I can do it without?

 

I cant select it (where field in(select..) because I get an input string

 

Thankss