UPDATE `2x`.w_routables SET _revenueCat = '(A) $1,000,000,000+' WHERE REPLACE(REPLACE(_revenueRange,'$',''),',','') BETWEEN 1000000000 AND 1.0E+24<BR>UPDATE `2x`.w_routables SET _revenueCat = '(B) $500,000,000 - $1,000,000,000' WHERE REPLACE(REPLACE(_revenueRange,'$',''),',','') BETWEEN 500000000 AND 999999999<BR>UPDATE `2x`.w_routables SET _revenueCat = '(C) $250,000,000 - $500,000,000' WHERE REPLACE(REPLACE(_revenueRange,'$',''),',','') BETWEEN 250000000 AND 499999999<BR>UPDATE `2x`.w_routables SET _revenueCat = '(D) $100,000,000 - $250,000,000' WHERE REPLACE(REPLACE(_revenueRange,'$',''),',','') BETWEEN 100000000 AND 249999999<BR>UPDATE `2x`.w_routables SET _revenueCat = '(E) $50,000,000 - $100,000,000' WHERE REPLACE(REPLACE(_revenueRange,'$',''),',','') BETWEEN 50000000 AND 99999999<BR>UPDATE `2x`.w_routables SET _revenueCat = '(F) $10,000,000 - $50,000,000' WHERE REPLACE(REPLACE(_revenueRange,'$',''),',','') BETWEEN 10000000 AND 49999999<BR>UPDATE `2x`.w_routables SET _revenueCat = '(G) $5,000,000 - $10,000,000' WHERE REPLACE(REPLACE(_revenueRange,'$',''),',','') BETWEEN 5000000 AND 9999999<BR>UPDATE `2x`.w_routables SET _revenueCat = '(H) $1,000,000 - $5,000,000' WHERE REPLACE(REPLACE(_revenueRange,'$',''),',','') BETWEEN 1000000 AND 4999999<BR>UPDATE `2x`.w_routables SET _revenueCat = '(I) $1 - $1,000,000' WHERE REPLACE(REPLACE(_revenueRange,'$',''),',','') BETWEEN 1 AND 999999<BR>