Charactor in a string

[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

 

[Ken Snell]

Use Like operator to do a wildcard search:

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