Hi Everett,

First of all, thanks for investing the time to help me out with this. 

At the suggestion of a co-worker, I've gone a slightly different route. Here's the...

Ok, Everett, I did what you suggested. 

select convert(varchar(10),visit_date,101)as VisitDate, visit_date,@minusdate,deposit_id,sub_obs

from subjective

 Everything I requested in the Select statement was correctly returned.  So the problem occurs when I attempt the comparison in...

Hey Everett,

Excuse my ignorance, but when you say throw the results into the Select clause, I'm not sure I understand. 

I have already run both as individual Select statements.  In each...

Hi Everett,

I did try that, but to no avail.

declare @MinusDate varchar(10)

  select @MinusDate=convert(varchar,getdate() -7,101)

    select deposit_id, sub_obs, convert(varchar(10),visit_date,101)as VisitDate

 from subjective

 where sub_obs like '%morphine sulfate%'

 and visit_date = @MinusDate

Hey guys,

Attached is my query, which still does not return the data that I know exists in visit_date field.

declare @MinusDate varchar(10)

  select @MinusDate=convert(varchar,getdate() -7,101)

 select deposit_id, sub_obs,visit_date

 from subjective

 where sub_obs like...

Many thanks, Brad!

Ok, Everett, will do. 

Thanks again!

Hi Everett,

Thanks for helping me out.  However, I'm afraid I don't completely undertand the query.  For instance, what does the 101 represent?

Thanks!