how to use variable with oracle like

[saynords]

Hi everyone,
Iam trying to use a variable in the where clause of an oracle statement but it isn't working

string cmdQuery = "SELECT A, B, C FROM TESTTABLE WHERE (A LIKE "%" + txtComments.Text + "'%)";

Can anyone tell me what I'm doing wrong? thanks so much in advance

[saynords]

Sorry meant to say LIKE % variable %

[debasisdas]

Try to use

string cmdQuery = "SELECT A, B, C FROM TESTTABLE WHERE A LIKE %" +"'" + txtComments.Text+" '%";

Hope that solves your problem.

[saynords]

Try to use

string cmdQuery = "SELECT A, B, C FROM TESTTABLE WHERE A LIKE %" +"'" + txtComments.Text+" '%";

Hope that solves your problem.

Hiya, thanks for this, below is the actual code (incorporating your suggestion I think) but I'm getting ORA-00911: invalid character :O( have I put a bracket in the wrong place?

string cmdQuery = "SELECT R_EXPEDIOREFERENCE ExpedioRef,R_CUSTOMERREFERENCE Reference,R_TITLE Title, R_REQUESTSTATUS Status, R_REQUESTTASK Task FROM aradmin.exp__request WHERE (r_source = 'KANA' AND R_EXPEDIOREFERENCE LIKE %" + "'" + txtExRef.Text + "'%))";

[debasisdas]

Why are you using brackets ?

Try this

string cmdQuery = "SELECT R_EXPEDIOREFERENCE ExpedioRef,R_CUSTOMERREFERENCE Reference,R_TITLE Title, R_REQUESTSTATUS Status, R_REQUESTTASK Task FROM aradmin.exp__request WHERE r_source = 'KANA' AND R_EXPEDIOREFERENCE LIKE %" + "'" + txtExRef.Text + "'%"