Select entries that starts with certain chars

[ennrike]

I have a table that has the primary key a string,

I would kike to select the rows that starts with certain chars, for exaple if I have the following entries:

P1234
P5647
12324
R4563
P4321

I would like to select those that starts with "P":

P1234
P5647
P4321

What would be the query?

 

[pbaldy]

Like

SELECT...
FROM...
WHERE Left(FieldName, 1) = "P"