Hello! Help me please. I have a deck-type view, where primary header - name, summary column - Code.

[NikaChan]

Hello! Help me please. I have a deck-type view, where primary header - name, summary column - Code. Code is a column with a 10 digits. When I filter the data in this view, typing, for example, the first 2 digits, I want to see only rows where these digits are at the beginning.
I mean, I have columns:

ID Name Code
1 Banana 1234567890
2 Apple 2345678901
3 Pear 3456789012
4 Cherry 4567890123

I select a filter - by code - type "23". I want to see only the second row. Now I see 1, 2, 4 rows because there is "23" in them.

[GrzWas77]

Hi,

Please share the SQL what you execute and why You label this to Dataform? I see that is pure SQL question...

Best,
Greg

[NikaChan]

I thought it was a matter of presenting information - the form of data. I apologize if I misinformed you! I'm not a native English speaker. To be honest, I don't even know what SQL is. I've attached a screenshot of my app.
The main problem is that my code has different variations in the number of digits. I can't type into the filter built into the app, for example, "77" and find all rows that start with 77. Only those that have "77" anywhere. I was hoping that the filtering method could simply be changed in the settings.

[NikaChan]

If it was always a 10 digit value, I could filter everything as numbers from "7700000000", but if the row has less than 10 digits, I won't see it.