Thanks to all of you that contributed. I used the CASE statement and it worked according to my criteria.

Thank you...

Sorry guys but it does not work. The update query updates all fields. Even the fields that have values. What I am trying to accomplish is to...

Thanks for the reply. I had tried replacing the OR with an AND, and I still get the same results.

IF EXISTS(SELECT F00069, F00026, F01298, F01299, F01300

FROM patient INNER JOIN

tumor...

Thank you for the response.  But I am using just HTML.

Thank you ,

What I am trying to accomplish is to return all the fields in the second table that contain the letter 'X' without having to type all the fields in the...