There is a DB created in interbase. There is a table NAZ . In it N_PUNKT - (cities). Tell me what kind of sql code to write to search for N_PUNKT . There you can configure something like a filter? Tell me how this is done?

    1 answer 1

     Π’ΠΎΠΎΠ±Ρ‰Π΅ смотря ΠΊΠ°ΠΊΠΎΠΉ Ρ‚ΠΈΠΏ Ρƒ вашСго поля N_PUNKT SELECT * FROM Naz WHERE N_PUNKT = <SomeValue> Π’ΠΎΠ·ΠΌΠΎΠΆΠ½ΠΎ Ρ‚Π°ΠΊΠΎΠ΅ N_PUNKT BETWEEN <SomeValue1> AND <SomeValue2> Π’ΠΎΠ·ΠΌΠΎΠΆΠ½ΠΎ Ρ‚Π°ΠΊΠΎΠ΅ N_PUNKT LIKE '%<SomeValue>%'
    • N-PUNKT - varchar kanechno. - Timi
    • Unfortunately, filters do not react to either between or like. Only sentences with comparison operators (<, <=, ==), etc. can be placed in the filter. In order to use between or like, you need to change the CommandText accordingly. - BuilderC