On 4/11/08, Teymur Hajiyev <[EMAIL PROTECTED]> 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

-------------------------------------------------------------------------
This SF.net email is sponsored by the 2008 JavaOne(SM) Conference 
Don't miss this year's exciting event. There's still time to save $100. 
Use priority code J8TL2D2. 
http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javaone
_______________________________________________
Firebird-net-provider mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Reply via email to