On Wed, 18 Oct 2000, Justin Long wrote:
> I want to do the following
>
> UPDATE newlink SET newfrom = substr(oldfrom,0,1) + '-' + substr(oldfrom,1)
The concatenation operator is '||' (two pipe symbols).
Brett W. McCoy
http://www.chapelperilous.net
---------------------------------------------------------------------------
My haircut is totally traditional!