[Solved] Query to find letter P in database

[jerc9024]

I am unable to execute database Query code can any one write me the code to find Letter P in my Data base

[UnklDonald418]

Try

Code: Select all

SELECT * FROM "YourDatabaseTableName" WHERE POSITION ( 'P' IN "YourFieldName" ) > 0

The SQL function
POSITION ( <binary value expr 1> IN <binary value expr 2> )
The character and binary versions of POSITION search the string value of the second argument for the first occurrence of the first argument string. If the search is successful, the position in the string is returned as a BIGINT. Otherwise, zero is returned.