Re: [firebird-support] Finding a single row

2016-05-26 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
26.05.2016 12:48, Ertan Küçükoğlu ertan.kucuko...@1nar.com.tr [firebird-support] wrote: > Below didn't work for me because complete card number is longer, and I do > lack SQL knowledge: > select * from FIYATKODLARI where Kodu like 'SB1%' select * from FIYATKODLARI where 'FullCardNumber'

[firebird-support] Finding a single row

2016-05-26 Thread Ertan Küçükoğlu ertan.kucuko...@1nar.com.tr [firebird-support]
Hi, I have a table where I keep some part from the beginning of a discount card number. Length of beginning is variable. User provides a complete card number at runtime, I need to find a single row in my table which begins as the complete card number, or I need to know no match exists in my