Problem In Using Wildcard Characters
-
Hi all! I have a Search application that has VB.net as the frontend and MS Access as the backend. I need to execute a query with a like clause "Select * from employee where emp_name like '*a*' This returns results results if i execute it directly at the db side; but returns no results on executing it through the application. (does not return any results if i use a wildcard charecter) Can anyone help me with this?? Thanks!!
-
Hi all! I have a Search application that has VB.net as the frontend and MS Access as the backend. I need to execute a query with a like clause "Select * from employee where emp_name like '*a*' This returns results results if i execute it directly at the db side; but returns no results on executing it through the application. (does not return any results if i use a wildcard charecter) Can anyone help me with this?? Thanks!!
Assuming you are using ADO or ADO.NET then the wildcard parameters are as follows % = Match any string _ = Match any character
Steve Jowett ------------------------- Sometimes a man who deserves to be looked down upon because he is a fool, is only despised only because he is an 'I.T. Consultant'
-
Assuming you are using ADO or ADO.NET then the wildcard parameters are as follows % = Match any string _ = Match any character
Steve Jowett ------------------------- Sometimes a man who deserves to be looked down upon because he is a fool, is only despised only because he is an 'I.T. Consultant'
-
Assuming you are using ADO or ADO.NET then the wildcard parameters are as follows % = Match any string _ = Match any character
Steve Jowett ------------------------- Sometimes a man who deserves to be looked down upon because he is a fool, is only despised only because he is an 'I.T. Consultant'
in addition I'd like to add (because I just had a simaler program where I encounterd this problem) that the wildcard * (or %) will not return 'null' values. (I haven't found any wildcard that will in access) so you will need to make shure that there is always a value in you're db fields otherwise I'm afraid you search will not work perfectly
-
in addition I'd like to add (because I just had a simaler program where I encounterd this problem) that the wildcard * (or %) will not return 'null' values. (I haven't found any wildcard that will in access) so you will need to make shure that there is always a value in you're db fields otherwise I'm afraid you search will not work perfectly