Need SQL help

[polina]

Hi

i have a simple question
i need a sql statement that will replace all '950' to '1' and all '957' to 2 in my Model column of the BlackBerry table.
Please advise the code

Thanks

 

[cogent1]

Excuse me asking, but why don't you just run an update query?

 

[pdx_man]

UPDATE BlackBerry SET BlackBerry.Model = IIf([Model]="950","1",IIf([Model]="957","2",[Model]));

If Model is not a text field but rather a number, remove the "

HTH