Select - Mailing list pgsql-general

Hi All,

I'm in trouble to build a select...
I have a table (for example) like this:


Table: Employee
empCod | empName | empDepth
---------+-----------+-----------
     1       |   Anand     |    any
     2       |   Oliver      |    any
     3       |    Peter      |    any
     4       |     Bob       |    any
     5       |    David     |     any
     6       |     Paul       |    any

Now I would like to select all employees which name begins with the letter
"P".....

> Select * from employee where "name-begin-with-letter-P"....  :-)

How can I do it ???

Thanks in advance,

Marcelo Pereira
Unicamp - Brazil