Hi ALL,

I'm using FIREBIRD 1.5 and I have a question.
What SQL has the best performance ?

1) select * from planoconta where nivel like '01.01%'

or

2) select * from planoconta where substring(nivel from 1 for 5) = '01.01'


Thanks for your attention.

---------------------------
João Luiz

[Non-text portions of this message have been removed]