Full text search

[krzysztof-dusko-velo]

add full text search in sql query.

some sql code

and some specja clause with filtering rows by text simillar to but applied online. Argumetation - search for some "special word" with no knwolage witch column can contains this and reulst set i to large to search in grid..

[KrzysztofDusko]

declare &SEARCHED = '''%ron%''';
select * from public.actor a
where a.last_name like &SEARCHED or a.first_name like &SEARCHED;

[KrzysztofDusko]

and for massive oprations on