Subject Re: sql string operations
Author Scott Moon
--- In, "martinknappe" <martin@...>
> -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 I usually start at
Or at least I did until I bought the IBPhoenix Developer CDs.


> thanx
> martin