Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Set Criterion to LIKE '*truth*'.

query design view

Using LIKE '%truth%' also works, and seems better to me because it is like the underlying SQL. However, the query tool turns % into * when generating the design form from SQL, so apparently, that's what the design form prefers.

Set Criterion to LIKE '*truth*'.

query design view

Using LIKE '%truth%' also works, and seems better to me because it is like the underlying SQL. However, the query tool turns % into * when generating the design form from SQL, so apparently, that's what the design form prefers..

Set Criterion to LIKE '*truth*'.

query design view

Using LIKE '%truth%' also works, and seems better to me because it is like the underlying SQL. However, the query tool design form turns % into *.

Set Criterion to LIKE '*truth*'.

query design view

Using LIKE '%truth%' also works, and seems better to me because it is like the underlying SQL. However, the query design form turns % into *.

Instead of modifying the Criterion each time, use the following Criterion to ask for the keyword to search.

LIKE LOWER ( '%' || :keyword || '%' )

Set Criterion to LIKE '*truth*'.

query design view

Using LIKE '%truth%' also works, and seems better to me because it is like the underlying SQL. However, the query design form turns % into *.

Instead of modifying the Criterion query each time, use the following this Criterion to ask for the keyword to search.

LIKE LOWER ( '%' || :keyword || '%' )

Set Criterion to LIKE '*truth*'.

query design view

Using LIKE '%truth%' also works, and seems better to me because it is like the underlying SQL. However, the query design form turns % into *.

Instead of modifying the query each time, use this Criterion to ask for the keyword to search.

LIKE LOWER ( '%' || :keyword || '%' )

Then enter truth in the box that appears.

Set Criterion to LIKE '*truth*'.

query design view

Using LIKE '%truth%' also works, and seems better to me because it is like the underlying SQL. However, the query design form turns % into *.

Instead of modifying the query each time, use this Criterion to ask for the keyword to search.

LIKE LOWER ( '%' || :keyword || '%' )

Then enter truth in the Parameter Input box that appears.

Set Criterion Criterion to LIKE '*truth*'.

query design view

Using LIKE '%truth%' also works, and seems better to me because it is like the underlying SQL. However, the query design form turns % into *.

Instead of modifying the query each time, use this Criterion Criterion to ask for the keyword to search.

LIKE LOWER ( '%' || :keyword || '%' )

Then enter truth in the Parameter Input box that appears.