Viewing 5 posts - 1 through 5 (of 5 total)
Thanks to all of you that contributed. I used the CASE statement and it worked according to my criteria.
Thank you...
November 10, 2004 at 12:44 pm
#529690
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...
November 9, 2004 at 3:13 pm
#529524
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...
November 9, 2004 at 2:53 pm
#529519
Thank you for the response. But I am using just HTML.
Thank you ,
May 26, 2004 at 11:11 am
#507894
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...
February 12, 2004 at 9:57 am
#493840