ok then, so how do i create a correlated join?

I just check the table design and find that Result is of char type.

stupid designer 

i'm actually surprised my self. when i compare the resultset of the query to that of the table i realized it didn't return the min of some values.

Look at the...

LOL.... great answer man ur a genious

just want sripts man

Select

Case when find_This = Like '%Pleasehelpme'   else 'u_Can't' end as [Can You]

etc

Thanks Jan ur a genious...... worked like a charm

don't understand........

what is the @category for?

any other suggestions guys?

i have an Action button, the result of which i want to display in a dynamic resultset.

However further research on the internet has led me to a solution, which is...

ok Jatinear, thx for the tip 

oops srry man been lots of demands here at work.

I never used fully qualified name to reference the object Patient_Dem2, which was in another db.

again srry guys

my mistake JLK... it's working now thx

1. AppointmentDate is a Datetime data type. 

ooops srry guys my bad i had AppointmentDate as char.

i changed it to datetime, now it works

thx again

should return>> ex

id      First Name      LastName       Appiontment Date .......etc

23       bill                  cower            05/17/2007    ...........etc

but it returns Null

like

id  First Name    LastName  Appointment Date..............etc

nothing here....

thx guys i got this prob resolved

thx much for the replies

what are the primary keys in you Input table?