Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

I want to compare the first 3 characters only

Former Member
0 Kudos

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

1 ACCEPTED SOLUTION

Former Member
0 Kudos

You can concatenate '%' in your parameter.

eg: 'ABC%'.

Hope this helps.

3 REPLIES 3

Former Member
0 Kudos

You can concatenate '%' in your parameter.

eg: 'ABC%'.

Hope this helps.

Former Member
0 Kudos

Hi Choa,

In the select statement we could write as 'ABC%' so that it could get all the entries starting with ABC.

Thanks,

sunil

Former Member
0 Kudos

write the select statement with abc% it will fetch all the things relevent to u