Case Insensitive Oracle Query

非常感谢。 Debs 解决方案 Hiya， 我正在查询我无法直接访问的Oracle数据库，因此无法更改服务器属性。 我需要对名称进行不区分大小写的搜索/或其他变量（C＃代码） ie ..... " SELECT Field1，FIeld2 FROM TableName WHERE（Field1 =''" +会话[" Variable"]。ToString（）+"''" ;; 如果会话变量iable是Debbie 它会带回DEBBIE，debbie，DeBbIe等。 有人可以帮忙吗？ 非常感谢。 Debs 你可以在=符号的两边上调以避免大小写差异。 您可以对=符号的两边进行UPPER以避免大小写差异。 你能给我一个例子，因为我确定我试过了吗 感谢Debs 你能给我一个例子，因为我确定我试过了这个 感谢Debs 问题可能是我需要将它与LIKE一起使用; o（ ie SELECT Field1，FIeld2 FROM TableName WHERE （Field1 LIKE''" + Session [" Variable"]。ToString（）+"''" ;; 这可能吗？ 谢谢 Debs Hiya,I am querying an Oracle database that I have no direct access to so cannot change server properties.I need to do a case insensitive search on a name/or other variable (C# code)i.e ....."SELECT Field1, FIeld2 FROM TableName WHERE (Field1=''" + Session["Variable"].ToString() + "''";so that if the session variable was "Debbie"it would bring back DEBBIE, debbie, DeBbIe etc.Can anyone help?thanks so much.Debs 解决方案Hiya,I am querying an Oracle database that I have no direct access to so cannot change server properties.I need to do a case insensitive search on a name/or other variable (C# code)i.e ....."SELECT Field1, FIeld2 FROM TableName WHERE (Field1=''" + Session["Variable"].ToString() + "''";so that if the session variable was "Debbie"it would bring back DEBBIE, debbie, DeBbIe etc.Can anyone help?thanks so much.DebsYou can UPPER both sides of the = sign to avoid case diffrences.You can UPPER both sides of the = sign to avoid case diffrences.could you give me an example because I ''m sure I tried thatthanks Debscould you give me an example because I ''m sure I tried thatthanks DebsThe problem could be that I need to use it in conjunction with LIKE ;o(i.eSELECT Field1, FIeld2 FROM TableName WHERE (Field1 LIKE ''" + Session["Variable"].ToString() + "''";Is that possible?ThanksDebs 这篇关于Case Insensitive Oracle Query的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！ 1403页，肝出来的..