关于模糊查询的问题！

花渊美步发布于 2008-10-10 13:21， 1770 次点击

SELECT *
FROM FinalConfirm
WHERE (((FinalConfirm.RefNo) Like '*' & [forms]![F_FConf]![cboRefNo] & '*'));

比如我在cboRefNo控件中输入了B10101-0003，就把数据库中B10101、B10101-0001、B10101-0002都找出来
我这个语句为什么实现不了？是哪里出了问题！！！

2 回复

IT浪子2008-10-15 09:50

应该是在cboRefNo控件中输入B10101能查找出你要查找出的结果的
试试看

花渊美步2008-10-20 10:03

strSQL = "SELECT * FROM FinalConfirm WHERE RefNo Like '*" & getOrgRefNo(Forms![F_FConf]![cboRefNo]) & "*'and refno <> '" & Forms![F_FConf]![cboRefNo] & "'"
Function getOrgRefNo(str As String) As String
    Dim i As Integer
    i = InStr(1, str, "-")
    If i > 0 Then
        getOrgRefNo = Left(str, i - 1)
    Else
        getOrgRefNo = str
    End If
End Function
我改成这样就实现了