Hi Riho-Rene,

A computed field can not take part the search, but you can created a view
and after use in other select.

CREATE VIEW "VW1"
AS
select (name1 || name2) as name from table


select name from VW1
where name like 'test'

Regards,
Marcelo

> ----- Mensagem original -----
> De: Riho-Rene Ellermaa [SMTP:r.ellermaa@...]
> Enviada em: quinta-feira, 27 de março de 2003 08:29
> Para: IBSupport (E-mail)
> Assunto: [ib-support] Searching query
>
> Is it somehow possible to do a search like this:
>
> select (name1 || name2) as name from table
> where name like 'test'
>
> I want to search some part of name from both fields - I dont know what
> part of data is in first or in second field.
> if name1="abcdef" and name2="ghij", then I could find the record if I
> serched for 'cd' or 'hi'
>
> Riho-Rene Ellermaa
> senior programmer
> Hansabank
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>