Embedded sql

Is that possible to put VARCHAR variable in condition WHERE ?

I declared host variables as:

VARCHAR key[20];
VARCHAR ItemName[20];

and:

strcpy(key.arr,"xyz");
key.len=strlen(key.arr);

Then I want select columns from a table:

EXEC SQL SELECT name INTO :ItemName
FROM CABLEBOX
WHERE KEY = :key;

When I run the program, I couldn't get the item name I want.But if I put the string 'xyz' behend = , it works. I wonder if I could put variable in WHERE clause. What to do if I really want to fetch somthing like this ? Received on Fri Jan 31 1997 - 00:00:00 CST