Hi,

> I've tried to make a subselect like this :

In where?

>
> ..............
> if ((search_name not null) and search_name in (select name from
> table) then
> begin
> ............
>
> But it seems that those kind of subselect are authorised.
> Somebody has some explainations.

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com