RE: Alphabetical search to and from

[misiaQ]

> Or :
> alter table users add first_f_name char(1) not null;
> create index first_f_name_idx on users (first_f_name);
> update users set first_f_name = left(first_name,1);

... and don't forget the trigger on insert, update to keep that new column
always up to date.

Regards,
m.


----------------------------------------------------------------------
Konkurs: Wygrywaj nagrody z Pudzianem!
Sprawd