oracle c# how to bind a variable with like

Question

I have this query

 string query = "SELECT * from IMALSO3.V_BN_IVR_ACCT_BAL_MNO WHERE PHONENO Like '%':mobileNumber";

                    using (OracleCommand cmd = new OracleCommand(query, conn))
                    {
                        cmd.Parameters.Add("mobileNumber", phone8Digits);

but it seems that i am binding wrong,

what is the correct way plase?

thanks

Sergey Kalinichenko · Accepted Answer · 2015-03-31 17:12:02Z

5

You need to remove the single quote, and put the wildcard marker % into the value itself, not into the query string:

string query = "SELECT * from IMALSO3.V_BN_IVR_ACCT_BAL_MNO WHERE PHONENO Like :mobileNumber";

using (OracleCommand cmd = new OracleCommand(query, conn)) {
    cmd.Parameters.Add("mobileNumber", "%"+phone8Digits);
    ....
}

answered Mar 31, 2015 at 17:12

Sergey Kalinichenko

729k85 gold badges1.2k silver badges1.6k bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Habib · Accepted Answer · 2015-03-31 17:11:58Z

1

Remove '%' from command text and pass it while adding parameter like:

string query = "SELECT * from IMALSO3.V_BN_IVR_ACCT_BAL_MNO WHERE PHONENO Like :mobileNumber";
using (OracleCommand cmd = new OracleCommand(query, conn))
{
   cmd.Parameters.Add("mobileNumber", "%" + phone8Digits);

If you want to compare phone8Digits like contains then use:

 cmd.Parameters.Add("mobileNumber", "%" + phone8Digits + "%");

answered Mar 31, 2015 at 17:11

Habib

224k30 gold badges420 silver badges446 bronze badges

Collectives™ on Stack Overflow

oracle c# how to bind a variable with like

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related