I have observed a strange behavior of BC filters in Text Data Types.
as you can see in the below image I have applied the Filter on Customer Name: E..K which means the name starting from E to K as far as I know the Dot Dot ".." are used as from value till To Value ?
in my case, the system is filtering the data from E to J only why is the system reduced by one value can anyone help me to understand that?
while data exist for K you can check in the below SS
this example is of the Demo database, why I am asking this question because I do have a customer requirement where I have created an Alpha Range Master and on the basis of that alpha range master we have to update a certain value in the customer master but that must depend on the alpha range only for example the field name is Registrar, so the master has defined like the customers whose name start from A to D would be assigned User A, E to K - User B, and so on.