Charactor in a string

  • Thread starter Thread starter alecgreen
  • Start date Start date
A

alecgreen

Hi

I am looking for a certain charactor (P) at the end of a string, but
the string length may vary, for example 1P, 123P or 12345P

Any ideas please

Thanks

Alec
 
Use Like operator to do a wildcard search:

SELECT *
FROM TableName
WHERE FieldName Like "*P";
 
Back
Top