I am running a simple query where I want to get multiple values from db. s

Hi Chandhini, I guess you have used "" inside the concat function. But from the attachment Eduardo has shared ,you should use single quotes instead of double quotes.
instr(ac!id,concat("|",columnname,"|"))>0
should be
instr(ac!id,concat('|',columnname,'|'))>0

Hi Subhankar,
I have used single quote also but geeting the same error message.

If this is SQL Server and not MySQL try the following query (placing the WHERE in a second line and making sure there's NO trailing space after the table name nor leading space before the WHERE )


select columnname from table
where instr(ac!id,concat("|",columnname,"|"))>0 .

Hi Eduardo,
I tried the above query but got the error message as "The database returned ARV's that may not be supported. Message: \\'instr\\' is not a recognized built-in function name."

That is because instr is a function in MySQL. You need to use the equivalent in SQL Server msdn.microsoft.com/.../ms186323.aspx