most preferable SQL

Which is most preferable between the below SQLs? In terms of consuming resources or fast execution.

1. Update Table1 set Reason = 'SX#' where
   (Sex <> 'M' or
   Sex <> 'F' or trim(Sex) <> '') and Key = inKey And Sub_Key = inSubKey and Reason is NULL;
2. Update Table1 set Reason = 'SX#' where
   (Sex not in ( 'M', 'F','') and
   Key = inKey And Sub_Key = inSubKey and Reason is NULL;

I am calling this SQL in the stored procedure. If there is another better way of writing SQL for the above query, please let me know.

Thanks in advance.

Amrith Received on Thu Feb 08 2007 - 07:52:09 CST