Hi, Hope someone can help. I'

[WP]

Hi,

Hope someone can help.

I'm creating a view :

CREATE OR REPLACE VIEW DB2_FDBTAB_CUR ( NUM_CODE,
ISO_CODE, EURO, DESCRIPTION ) AS select tbcode,tbcomp,tbcomp,tbdes1 from olyftch.fdbtab@esdev01a.db2 where tbid='040'

However, the ISO_CODE is only the first 3 chars of tbcomp. I'd like to only have the first 3.- Left(field,3) but not sure of Oracle syntax.

The EURO indicator is position 57 of tbcomp (tbcomp is 80 char) and again i'd like to just select the substring of tbcomp required.



Bill Paton
william.paton@ubsw.com

http://www.neptune400.co.uk/

Check out

http://www.deepturtle.ch

 

[sem]

substr(tbcomp,1,3) returns first 3 characters.

 

[WP]

Sem,

Thanks for the speedy reply. I knew it had to be simple! Bill Paton
william.paton@ubsw.com

http://www.neptune400.co.uk/

Check out

http://www.deepturtle.ch