tukapen
|
| Posted: 05/01/2002, 6:11 AM |
|
I have create a search form but how could I customize the where condition. Because it look like let say I need to search for person start with the name A, it will infact return all name contain A
How could I modify the SQL so that SQL look likes this A% rather than %A%
|
|
|
 |
Nicole
|
| Posted: 05/02/2002, 5:58 AM |
|
just open Data Source window from Properties window->Data tab->Data Source. Select input parameter modification and change 'Condition' to "begins with (like'...%')"
|
|
|
 |
tukapen
|
| Posted: 05/02/2002, 6:49 PM |
|
Hi I have tried out but still didn't work as expect
|
|
|
 |
Nicole
|
| Posted: 05/03/2002, 4:48 AM |
|
Ok, how does it work?
BTW, what programming language do you use?
|
|
|
 |
|