Hi all. I am working on a ASP NET 2.0 (vb net) site. I have created an objectdata source that is bound to a gridview. I want to filter the gridview based on matching the first letter of the firstname column with an inputted value.
I have previously matched letters using the following expression:
odsAdminSubmissionAll.FilterExpression = "SubFirstName LIKE '%" & txtSearch.Text & "%'"
In order to try and match the first letter I did the following:
odsAdminSubmissionAll.FilterExpression = "LEFT(SubFirstName, 1) = '" & strLetter & "'"
The error I got was:
"Exception Details: System.Data.EvaluateException: The expression contains undefined function call LEFT()."
Anyone point me in the right direction?
many thanks in advance!