Informix where clause - how to parameterize the column-name

Path: emory!gatech!prism!gt8963a From: gt8963a@prism.gatech.EDU (MCCARTNEY,JEFFREY ELWOOD) Newsgroups: comp.databases Keywords: Informix Message-ID: <31474@hydra.gatech.EDU> Date: 17 Jun 91 11:42:12 GMT Organization: Georgia Institute of Technology I'm trying to parameterize the column-name in an Informix WHERE clause. Here's what I mean: SELECT * FROM customer WHERE col_var = NULL ^^^^^^^ I want to be able to make it a var such that I can fill in the column-name at run time. Additionally, I'd like to be able to fill in the column-name from the systems tables as well. Any ideas? (The Informix doc says it can be an expr as well as a column-name. And I've gotten it to compile with a variable, just no selected rows.) Thank you -- uucp: ...!{decvax,hplabs,ncar,purdue,rutgers}!gatech!prism!gt8963a Internet: gt8963a@prism.gatech.edu