Hi,
I made data access page which is generated on behalf of a query.
In the query desing i chose parameter input option as criteria for one field, so when I open try to open that DAP first I get form for that parameter input.
All values in that parameter lookup column are text datatype and contains names and lastnames. Those two words(Name Lastname) have upper firstcase and because of that values that are inputed in the form must match case, they are case sensitive.
Question is how can I implement function which will provide input case insensitive values...
For example:
I put values "john dohn" in form which gives me rows which have values John Dohn
I made data access page which is generated on behalf of a query.
In the query desing i chose parameter input option as criteria for one field, so when I open try to open that DAP first I get form for that parameter input.
All values in that parameter lookup column are text datatype and contains names and lastnames. Those two words(Name Lastname) have upper firstcase and because of that values that are inputed in the form must match case, they are case sensitive.
Question is how can I implement function which will provide input case insensitive values...
For example:
I put values "john dohn" in form which gives me rows which have values John Dohn
