Can you have a select and update statemnt execute in one sql statement. I have a asp script and instead of creating a recordset to get the value then add 1 to it I'd like to get the value of a field(int) and update it in one sql statement if a flag = true.
if flag = true
e.g sql= select myvalue from tbl_main. add 1 to myvalue.