The IN function [message #440631] |
Tue, 26 January 2010 06:40  |
Derek N
Messages: 80 Registered: September 2002
|
Member |
|
|
hello
I have the following SQL query:
select * from table_a
where cat_type in (select a_col from table_b where rownum =1);
The value in a_col (which is a varchar2 field) is ('1,'2','3',4'). The brackets are also stored in this field.
Field cat_type from table_a varies from 1 to 4. I want to select from table_a where cat_type in 1,2,3,4.
The select does not return any values. Any way around this?
|
|
|
|
|
|