How to pull data from field with multiple values in SQL

Question

I know this is going to be so simple but for the life of me I cannot figure it out. I am trying to pull denial codes in my query that are either 35 or 48. The thing that is holding me up is a lot of these products have multiple denial codes and can contain my denial code but the results are only bringing back the products with the exact 35 or 48 code. For example product one might have denial 10,35,93. My query is not returning this line, instead its only returning those with 35 only. Thank you in advance.

SELECT * 
FROM PRODUCT_DENIAL_DETAILS
WHERE SOLD_DATE > SYSDATE -90
AND DENIALCD IN ('35','48')

Please show your table schema, and sample rows.

OldProgrammer
– OldProgrammer

2014-11-17 19:15:09 +00:00
Commented Nov 17, 2014 at 19:15 — OldProgrammer
– OldProgrammer, Commented Nov 17, 2014 at 19:15

Maheswaran Ravisankar · Accepted Answer · 2014-11-17 19:22:15Z

1

Then you have to use a wildcard in your condition.

 AND (DENIALCD LIKE '%35%' OR DENIAL CODE LIKE '%48%')

This will bring back any rows with the 35 or 48 in the field.

edited Nov 17, 2014 at 19:22

Maheswaran Ravisankar

17.9k6 gold badges50 silver badges69 bronze badges

answered Nov 17, 2014 at 19:16

Vincent Ramdhanie

103k23 gold badges143 silver badges196 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

tia97 Over a year ago

Ahh I just knew it was going to be something simple! Thank you so much :)

Vincent Ramdhanie Over a year ago

Although, I would suggest that you rethink the design of the relations in your database and maybe just keep a single code per row which makes your querying etc a little better.

Collectives™ on Stack Overflow

How to pull data from field with multiple values in SQL

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related