Why Does This simple statement not work??<BR><BR>Update InvSumm2 <BR> set sTypeCompany = 'HELP' <BR>where sTypeCompany <> 'Private'
do you get an error or does the statement not work as intended? is the table name correct? is the field name correct? is the field datatype correct? need more info.
are you sure there any records with sTypeCompany equal to 'Private' and not 'private' OR 'PRIVATE'?
where sTypeCompany <> 'Private' will not account for NULL values in that field. So in other words, all records that have a sTypeCompany = NULL will NOT be updated.
I looked at the original question quick and thought it read <BR><BR>WHERE sTypecompany = 'Private' instead of <>