i used this query of searching name
SELECT “Table”.* FROM “Table”, “Table_filter” WHERE ( ( ( UPPER ( “Table”.“Name” ) LIKE ‘%’ || UPPER ( “Table_filter”.“Name” ) || ‘%’ ) OR ( “Table_filter”.“Name” IS NULL ) )
Example ;- i search Mark it returns Mark, Mark Pop, Rock Mark but i want to search only Name Mark or if i search Rock Mark it should return only Rock Mark.
i tried many option but all not solved my purpose.
Thanks in advance