On Tue, Apr 17, 2001 at 09:23:02AM -0300, Marcelo Pereira wrote:
> Hi All,
>
>
> Now I would like to select all employees which name begins with the letter
> "P".....
>
> > Select * from employee where "name-begin-with-letter-P".... :-)
>
select * from employee where email ~ '^P';
or if case does not matter
select * from employee where upper(email) ~ '^P';