select count(*) from pb where name < 'John Smith';
Thx... duh guess I should have thought of that.
--
No virus found in this outgoing message.
Checked by AVG.
Version: 7.5.476 / Virus Database: 269.10.6/902 - Release Date: 15/07/2007 14:21
Colin Manning <[EMAIL PROTECTED]> wrote:
Then assume I'm writing an app that displays the entire directory in a
window, ordered by name/number etc using a scrollbar to move up and
down.
So I might have:
CREATE TABLE pb (id INT, name VARCHAR(40),...);
CREATE INDEX pb_idx_name ON pb(name);
..
Not
2 matches
Mail list logo