Thanks Gail,

This does work.. can I add something to this....

Row_number gives me the count of the number of clients records based on the Starttime

Is there a way to get...

I'm sorry....

I think I just need an And statement

"and dbo.[BPRS Scores].Score <> 33"

Thanks spiff...

Works great, need to do some reading on compare

Thanks Again

Hi Spiff,

Although Andrew's way will work, if someone say puts in "NoSHow" it will miss it.

Just not sure how to set it up, really don't want you to do my...

Thanks and sorry, I used the Like in the stored proc that I was pulling the data

but the replace was what I was looking for

Thanks Again

no, just using a LIKE '%canceled%' on a note field to find repords that have the word "cancelled" in that field

so it can be anywhere in that field

Thanks for getting back.

I would like to highlight only the word "Cancelled" in the text.

But this will work if I can't do that

Thanks Again

Thank you.. I am looking/looking up these now

Thanks Luis, great Idea, didn't even think of that ...

Great I think this will work after I do some data checking

added to the where to also show null values

SELECT distinct T1.[last name],t1.[first name],ENum,t2.Anum,T2.lname ,t2.Fname,

FROM ECLINICIAN_Info T1

LEFT JOIN ACLINICIAN_Info T2

ON...

Thanks for getting back

True, and I didn't really explain it right, sometimes the ENum and ANum are there but don't match and would like to select the Anum so the...

This info is great..

Thanks so much

wow I surprised myself I actually figured it out after I put this up

I guess see it on a different screen helped...lol

I just needed the name at that level

DISCHARGEMINUTES.value('(./Discharge_x0020_Time/time/Minute)[1]',...

CEILING( DATEDIFF(second,Information.[Start Time],Information.[End Time])*4 / 60.00 / 60.00) / 4 AS Rounded_Hours,

Works as I needed , and I now have other options in my libray

Thanks so much!!

Yes sorry , bad example, I am looking to round up to the nearest 1/4 hour