Merging three fields into one

From: Daniel Cloutier <danielcloutier_at_web.de>
Date: 03 Dec 2001 15:08:55 +0200
Message-ID: <3c0b877e$1@netnews.web.de>

Hello!

I need to merge 3 fields into one single one. All fields are in the same table. So, I tried to do an UPDATE where it says UPDATE TABNAME SET TARGETFIELD = FIELDSRC1 & FIELDSRC2 & FIELDSRC3; but that doesn´t work. Instead, SQL Plus keeps asking me to provide a new value for 'FIELDSRC2' etc.

Can someone please help me out here? I ´m really stuck here.

Thanks in advance!

Bye,
Daniel

-- 
__________________________________________________________
News suchen, lesen, schreiben mit http://newsgroups.web.de

Received on Mon Dec 03 2001 - 07:08:55 CST