From: Jiri C. <di...@ci...> - 2008-04-11 12:18:06
|
On 4/11/08, Teymur Hajiyev <tha...@af...> wrote: > So, it is not possible to search inside TEXT field??? First, this is question for fb-support list, not for this. Second, why don't you just try to run command in isql? Third, in FB2+ you can use txt blobs for some operations, but only items that fit varchar(32k): create table abc (t blob sub_type text); insert into abc values ('abcba'); commit; select * from abc where t like '%c%'; PLAN (ABC NATURAL) T ================= 14a:0 ============================================================================== T: abcba ============================================================================== COMMIT; drop table abc; -- Jiri {x2} Cincura (CTO x2develop.com) http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com |