Subfield

[upaliwije]

Hi Friends

In may data table the following field exits

BANK_BRANCH

7287-001

7287-030

7287-050

7268-001

7750-005

if(SUBFIELD(BANK_BRANCH,1,4)='7287','SEYLAN','OTHERS')AS  BANK,

I have written above syntax and but in the results Retrun 'OTHERS' for  record. Pls tell where I am wrong

[yuvraj]

It should be

if(SUBFIELD(BANK_BRANCH,'-',1)='7287','SEYLAN','OTHERS')AS  BANK

Regards,