Thank You Guys...much appreciated!!

All, here is a sample data set. So basically I am looking for members who are in the new months table and not in the previous months. They...

David,

Thanks for pointing me in the right direction.

I got it to work with the following:

select

Case

when CHARINDEX(' ', Drug_name) > 0

then LEFT(Drug_name,CHARINDEX(' ', Drug_Name)-1) else Drug_Name

end...

David,

Thanks for that query, it has me in pointed in the right direction but I ran the query and it seems like I am missing something.  It does'nt seem like...

I was trying to get a average of a person to hundreth place.  I was able to do it a 3 step process by putting into temp tables and I...

Thanks guys, that helped!!

Thanks Mark, that gave me the same results.  I might have to create a lookup table with a truncate drug name in order to total prescription and pay amount.

Thanks for...