Filter by Start Letter

Business Central/NAV Developers Forum
1

I want to filter a certain field of a table with data that starts with the leter “E”. What the code to write. i tried this but its not working. please help.

Emp_Payroll.SETFILTER ( Emp_Payroll.“Job Title”,*E );

Thanks in advance.

Festus

2

Hey Festus,

Try with SETFILTER(“Title”,‘E*’) insted.

3

Hi Festus,

Erik has given you the solution. As thi i not a code field and you may not want this to be case sensitive so you can use :

Emp_Payroll.SETFILTER ( Emp_Payroll.“Job Title”,’@E*’ );

4

Thanks Guys. It has worked perfectly. I appreciate.

Thanks once again.