SQL BUILDER - How can I include a context variable in the WHERE clause

[Anonymous]

Hi:
I want to use in an sql query a value prompted in the context. (I'm using an INFORMIX database).
I've created the variable called "myvariable" . When I run the job, it prompts for a value, just as I want.
When I want to include it in my query, I type Ctrl+SpaceBar and I can select my variable from a list (it was called "context.myvariable".
The query appears so:
"SELECT * FROM mytable
WHERE column1 = context.myvariable"
The system rejects my code saying "COLUMN context IS NOT FOUND IN ANY TABLE IN THE QUERY".
Please help me to mend my syntax.
Thank you very much in advance.
Juan Carlos.

[_AnonymousUser]

By the way I do know that the From is missing that is because it was very long

[Anonymous]

Hi chrisBolduc,
Can you make it success if you use the value directly without variable in query?
Would you mind elaborating your case with an example with input and expected output values?
Best regards
Sabrina