I need to replace whatever is in fieldA now with 00000000




and need to limit the 1st test to records #1-50




I have to make a mass change to 10,00 lines in a table within OSCmax



I got part of it the statement and I think it is right, but I want to test by limiting the effected records







will this work??
UPDATE cart_osc2 SET fieldA = replace(fieldA,*,"00000000");

What would be the rest of the statement to limit to record 1-50??

thanks..