Thanks...That's what I thought at 1st. But, it's pulling the BINNO for Grant instead of Commercial when I use that. I want Commercial 1st if they have it.

Gail, I appreciate all of the help you've given me.

Oh, I'm sorry. I didn't know her name and just called her by her screen name. Wasn't trying to be rude or anything.

Sorry...I'd like to round it to 8

Gila...that worked great. Thanks again! Quick question. Some of the results from that statement are 7.8400 (for example). I'd like to round that. But, when...

Gila, there are only numeric values....thanks again.

Ok, got it. Varchar(5)

the datatype for that field is a Varchar

Gila...just wanted to follow up to see if you had any luck with this

The values from labels.bagdisp range from 2-60. Is that what you are asking for?

Gila, I'm not 100% sure what the range is in the Bagsdisp field. I'd imagine up to 100 at the very highest. The numbers that the field is...

Gotcha...ok, Labels.bagsdisp is a varchar. Would I need to convert that to a number? if so, how would I do that?

I'm new to SQL...how can I tell? I brought the labels.bagsdisp field into the query. The value is 2. I'm just trying to multiply that times 0.9

Thanks...you were right. This patient had a different NDC code. So, I changed the parts.ndc to the correct code and now I'm getting the following error:

Arithmetic overflow error...

Wow, that was easy.. haha....thanks!