SQL*Loader - concatinate strings

From: jeb <jeb_at_fayettevillenc.com>
Date: Tue, 05 May 1998 18:04:06 -0400
Message-ID: <354F8CD6.F8CF6809_at_fayettevillenc.com>



Is it possible to concatinate fields using SQL*Loader. Example to translate a SSAN from 9->11 or 11->9 charachter format.

Example:
ID POSITION(1,2),
SSAN_FIELD POSITION(3,5) & "-" & POSITION(6,7) & "-" & POSITION(8,11), NAME POSITION(12,40).... Thanks JB Received on Wed May 06 1998 - 00:04:06 CEST

Original text of this message