Thank you.

thank you for the reply

Please check the attachment

here am unable to use Update statement as it shows error.

please check and help

thank you

THANK YOU.

WOW.Thank you Chris

it worked.

Thank you Luis

i found its not recommended so i have requested to handle it in the front end .

THANK YOU FOR THE REPLY

THANK YOU FOR THE REPLY LEMPSTER

IT WORKED:)

Thank you for the reply chris.:-)

It Worked

Thanks a ton Mitesh

Thanks a ton Koen.

it worked. 🙂

Dear Erland,

Thanks a lot for your Reply and the link provided, but it seems it will not satisfy my client requirement.

please find the table definition and sample details as you...

Thanks a ton Luis

it worked with slight modifications.

Thank u for reply hanshi,

If I pass 'vat' alone output should be VAT from col1

If I pass 'cst' alone output should be CSR from col1

Thank u

Dear Sean,

please find the DDL and insert statements below

drop table test

CREATE TABLE TEST

(

COL1 CHAR(10),

COL2 CHAR(20)

)

INSERT INTO TEST (COL1, COL2) VALUES ('Bed+Vat', 'Vat')

INSERT INTO TEST (COL1, COL2) VALUES ('Bed+Vat',...

Thank you David,

here are the sample rows

first row:

IN010000000040011 20000101GOODS AND SERVICES TAX ...