Subject Re: [ib-support] Searching query
Author Paul Vinkenoog
Hi Riho-Rene,

> Is it somehow possible to do a search like this:
> select (name1 || name2) as name from table
> where name like 'test'

That doesn't work, but this does:

select (name1 || name2) from table
where name1 || name2 like 'test'

If you use 'like' like this, I think it behaves as '='

> 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'