--- In firebird-support@yahoogroups.com, "martinknappe" <martin@...>
wrote:

>
> -how do i concatenate strings? ( string + string doesn't work)

Double-pipe (||)

> -what's the escape character in a string (so that i can search for
> strings containing for example '%')

You can define your own escape character using ESCAPE <val> in your
search statement.

This was really not hard to find. There is plenty of documentation
available at www.ibphoenix.com. I usually start at
http://www.ibphoenix.com/main.nfs?a=ibphoenix&page=ibp_download_documentation
Or at least I did until I bought the IBPhoenix Developer CDs.

Scott

>
> thanx
>
> martin
>