SQL Language (MOSC)

MOSC Banner

SQL: display note for specific string combine with column

edited Sep 2, 2017 5:00AM in SQL Language (MOSC) 2 commentsAnswered ✓

Hello Guru,

Having below sample data

create table XXTEST (DOCNBR VARCHAR(10),RNBR VARCHAR(20));

insert into XXTEST (DOCNBR,RNBR) values ('149610978','149610978-B1');

insert into XXTEST (DOCNBR,RNBR) values ('149610978','149610978-B2');

insert into XXTEST (DOCNBR,RNBR) values ('149610978','149610978-C1');

insert into XXTEST (DOCNBR,RNBR) values ('149610978','149610978-C2');

insert into XXTEST (DOCNBR,RNBR) values ('149610978','149610978-S1');

What I want is to display 'SPECIAL' if in RNBR I have combination of DOCNBR and -S. I tried below query but no luck. Please advise

SELECT X.DOCNBR,X.RNBR,

CASE  WHEN X.DOCNBR ||'-S' = X.RNBR

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center