sir, I have one more qustions, if this table contains three fileds then how can i update
iduvidualy in a single statement.

UPDATE mytable
SET myfield = @NewValue
WHERE < whetever conditions >
AND myfield <> @NewValue
>
>While updating data in the server, i want to skip the field if and only if the new value
>and old the values are same. Othewise i want to update the field with new value.
>how will i write Sql Statement for this.
>

Regards
Abdulla