Ibrahim,

> TABLE2.DESCRIPTION field type is Varchar(2000)
>
> when i run the query, sometimes server is crashing
> but it becomes sometimes, not always.
> and server log is that
> C:\Program Files\Borland\InterBase\bin\ibserver.exe: terminated abnormally
> (-1073741819)

Can you elaborate if it is just crashing if the content of the
VARCHAR(2000) fields is exceeding a certain size?

I can remember having had problems with before using IBObjects.

Luc.