Help with creating serch string using "Right" for partial sring search
Posted on 2014-02-18
I tried to build a Query string to search a table using the code below
Dim SearchCriteria As String = "Right (SN,3) IN (" & xyz & " ) AND CA LIKE " & xyzwa & ""
But received the following error:
The expression contains undefined function call Right().
How do I avoid this error?