Selecting Values with the Letter P

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,
I have a query that contains a text filed will all the project codes of the
clients we deal with. Most of them are three digit numbers (I.e. 707, 708,
709). However, if we are writing a proposal we stick the letter P before the
three digit code (i.e. P707, P708, etc). Therefore I was wondering if there a
string I could put in the criteria that would allow me to only select
proposals (i.e. records containing the letter P).

thanks in advance,
 
Back
Top