hi
i'm currently trying to write an sp for my database that does some
string operations but i don't know how neither do i find the adequate
resources that could guide me on string operations so please tell me
where i can find them..
the 2 most pressing things:

-how do i concatenate strings? ( string + string doesn't work)
-what's the escape character in a string (so that i can search for
strings containing for example '%')

thanx

martin