Hello Master . . .

my database name study : 

name           ID           Desk

michel    1  B

michel     1          B

michel          1  B

michel    1  B

michel   1          B

michel   1  B

jordan   2  B

jordan   2  B

jordan          2  B

jordan   2  B

jordan   2  B

jordan          2  B

i want to update  fied Desk in databese become :

name           ID           Desk

michel    1  A

michel   1          A

michel   1  A

michel    1  B

michel   1          B

michel   1  B

jordan   2  B

jordan   2  B

jordan          2  B

jordan   2  B

jordan   2  B

jordan          2  B

only 3 rows updated, i want to use case condition or if condition combination BETWEEN but not work.  "please help me"

• Edited by mulkyuky 32 minutes ago

What is the query used for updating the table?

Also, post DDL and sample generation scripts.

Name : michel michel michel michel michel michel

Id  :    1       1   1        1  1   1

Desk :   B       B         B   B      B   B

i want to update field desk database :

Name : michel michel michel michel michel michel

Id  :    1       1   1        1  1   1

Desk :   A       A         A   B      B   B

update PencairanKredit Set Keterangan = 'A' where  No = '" & txtNoPembiayaan.Text & "' AND Angsuran between '" & txtAngsuranke.Text & "' AND '" & txtBetween.Text & "' ;