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
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
Comment