first reply is yes
and how would I take out the address2 and address3 from the one address?
Also some addresses will be nULL values
I've show how INSTR can be used to locate a delimiter string (e.g. ' ' or '||') in the address, and also how SUBSTR can be used to take out part of the address between delimiters. Getting address2 is similar to getting address1, except that you start after the first space, and go up to the '||' delimiter. You need to experiment with using these functions yourself.