以文本方式查看主题 - Foxtable(狐表) (http://foxtable.com/bbs/index.asp) -- 专家坐堂 (http://foxtable.com/bbs/list.asp?boardid=2) ---- 请问LIKE语句是否识别大小字,如果转换为大写,以下语句那里没书写正确 (http://foxtable.com/bbs/dispbbs.asp?boardid=2&id=186473) |
-- 作者:9EQ98 -- 发布时间:2023/5/6 4:58:00 -- 请问LIKE语句是否识别大小字,如果转换为大写,以下语句那里没书写正确 请问LIKE语句是否识别大小字,如果转换为大写,以下语句那里没书写正确 Dim DT_Name As String = "采购计划明细" Dim DC_Name As String = "预计单价" Dim Edrs_Filter As String = "" Edrs_Filter = "[Enabled] = 1 And [DT_Name] = \'" & DT_Name & "\' And UPPER([Res_DC_Name]) Like \'%" & DC_Name.ToUpper() & "%\'"
|
-- 作者:有点蓝 -- 发布时间:2023/5/6 8:48:00 -- like不区分大小写的 |