Subject in() in firebird
Author checkmail



I would like to a variable for the in-function


Declare str_var varchar(20)


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