Why is This If statement not recognising the 'Then'?

Question

Why is this If Statement not recognising the Then's and is just saying "Expression Expected" with a blue underline under the two last Then's, the first one is fine.

If fst <> "" And lst = "" Then
    cmd = New OleDbCommand("SELECT * FROM Customers WHERE FirstName='" & fst & "';", cn)
ElseIf fst = "" And lst = <> Then
    cmd = New OleDbCommand("SELECT * FROM Customers WHERE Surname='" & lst & "';", cn)
ElseIf fst <> "" And lst = <> Then
    cmd = New OleDbCommand("SELECT * FROM Customers WHERE Surname='" & lst & "' AND FirstName='" & fst & "';", cn)
End If

Also please see [How do I create a parameterized SQL query? Why Should I?](http://stackoverflow.com/q/542510/11683) — GSerg, Apr 12 '14 at 20:21

score 0 · Answer 1 · answered Apr 13 '14 at 14:10

0

If fst <> "" And lst = "" Then
    ' statement...
ElseIf fst = "" And lst = "" Then
    ' statement...
ElseIf fst <> "" And lst = "" Then
    ' statement...
End If

answered Apr 13 '14 at 14:10

Neverr Myndd

1
1
1

Why is This If statement not recognising the 'Then'?

1 Answers1