Subject | SV: [firebird-support] Re: Problem slow sorting/distinct in Firebird |
---|---|
Author | Poul Dige |
Post date | 2012-11-20T04:25:48Z |
Sorry for interfering - but I just wanted to say: Brilliant trick, Fabiano :)
I will remember that one!
Regards,
Poul
Fra: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] På vegne af Fabiano
Istead of:
(LCASE(art.Artikelnummer) like '%a4 papier%') or
(LCASE(art.Artikelnr_leverancier) like '%a4 papier%')
Use:
(LCASE(art.Artikelnummer|| art.Artikelnr_leverancier) like '%a4 papier%')
[Non-text portions of this message have been removed]
I will remember that one!
Regards,
Poul
Fra: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] På vegne af Fabiano
Istead of:
(LCASE(art.Artikelnummer) like '%a4 papier%') or
(LCASE(art.Artikelnr_leverancier) like '%a4 papier%')
Use:
(LCASE(art.Artikelnummer|| art.Artikelnr_leverancier) like '%a4 papier%')
[Non-text portions of this message have been removed]