WHERE clause with strpos

Question

create table test(variable varchar(20), col001 real, col002 real);
insert into test values('col001',1,2);
insert into test values('col002'3,4);

Now, I'd like to query this to get a submatrix:

 select variable, col001, col002
 from test
 where strpos("col001,col002", variable) > 0

Why doesn't this work?

"col001,col002" is a delimited identifier, i.e. the dbms thinks it's a column name. Use single quotes for string literals. — jarlh, Sep 08 '15 at 06:32
http://www.postgresql.org/docs/current/static/sql-syntax-lexical.html#SQL-SYNTAX-IDENTIFIERS — , Sep 08 '15 at 06:38

score 1 · Accepted Answer · answered Sep 08 '15 at 06:36

1

"col001,col002" is a delimited identifier, i.e. the dbms thinks it's a column name. Use single quotes for string literals.

I.e.

select variable, col001, col002
from test
where strpos('col001,col002', variable) > 0

answered Sep 08 '15 at 06:36

jarlh

score 0 · Answer 2 · edited May 23 '17 at 11:58

0

There is no STRPOS is MsSQL:
reference : SQL Server: any equivalent of strpos()?
you can write the query like this in MsSQL:

SELECT variable, col001, col002
FROM test
WHERE CHARINDEX('col001,col002', variable) > 0

edited May 23 '17 at 11:58

Community

answered Sep 08 '15 at 06:41

Biswabid

2

And what tells you that the OP is using SQL Server? – Frank Schmitt Sep 08 '15 at 06:44

2 Answers2