platform : xp pro / Visual studio 2002 / firebird.net
I want to retrieve all records that name contain a certain string , how should I do it ?
( This is like a search option )
ok I find my answer : select name from table where name like %bush%
Then , how to add 2 string field in a statement
my code
'select (addr1+addr2) as address' , it gives error .
Firebird uses the double pipe for concatenation.
select addr1 || addr2