10-08-2007 8:08 AM
Hi Gurus,
Is there a function module that gets the first 3 characters of the parameter to compare the first 3 characters of the database?
Parameter: ABC*
Database table values:
ABCDE
ABCDEF
ABCDEFG
AZZBBEF
The result will be 3. It will get all the values because the first 3 characters are the same with the parameter.
Is there a function module for that?
Thanks in advance.
Benedict
10-08-2007 8:10 AM
You can concatenate '%' in your parameter.
eg: 'ABC%'.
Hope this helps.
10-08-2007 8:10 AM
You can concatenate '%' in your parameter.
eg: 'ABC%'.
Hope this helps.
10-08-2007 8:12 AM
Hi Choa,
In the select statement we could write as 'ABC%' so that it could get all the entries starting with ABC.
Thanks,
sunil
10-08-2007 8:18 AM
write the select statement with abc% it will fetch all the things relevent to u