Hi,
I have this table .DBF (FP) that is available from an ODBC Connection
I need to search for Lastname and First name WHERE
No matter what the user types: LASTNAME, lastname or Lastname
for my code to search like: LASTNAME, lastname or Lastname.
How do I do that:
this is the actual query:
"SELECT * FROM vehicle WHERE (v_lastname LIKE '" & v_last_name & "%' AND v_firstnam LIKE '" & v_first_nam & "%') ORDER BY v_lastname ASC, v_firstnam ASC;"
Could you help me?
If you need more detail please post.
Thank in advance.
Vico1
Start Free Trial
