substring

[alexi]

hi, help! i need to extract the branch name from field bankname using as400/sql commandline.

select bankname from tbBank
sample data

citibank - head office
citibank - philippines
citibank - singapore
citibank - hongkong

i need to output the string after (-) dash
example output

head office
philippines
singapore
hongkong

[B.Hauser]

Re: substring

Hi,

try the following:

Select BankName, substr(BankName, posstr(BankName, '-') + 2)  as Branch
  from tbBank 

Birgitta

[alexi]

Re: substring

hi Birgitta,

i just changed substr to substring and it worked.. thank you very much..