Monday, October 13, 2008

Phone Numbers Update (2)


  1. Check if the phone number doesn't contain any characters. (valid number)
  2. Check if the area code is 965 or null (assumption).
  3. Check if the phone number's length is 7 (6 for numbers that start with 8).

--------

  1. MOC (add 20000000): 2, 3, 41, 42, 43, 45, 46, 47, 48, 49, 500, 503, 504, 52, 53, 54, 551, 552, 553, 56, 571, 572, 573, 574, 575, 576, 577

  2. ZAIN (add 90000000): 40, 44, 702, 71, 72, 73, 74, 75, 76, 78, 79, 9

  3. WATANIYA (add 60000000): 501, 502, 505, 506, 507, 508, 509, 51, 550, 554, 555, 556, 557, 558, 559, 570, 578, 579, 58, 59, 6, 700, 701, 703, 704, 705, 706, 708, 709, 770, 771, 772, 773, 774, 775, 776, 778, 779

  4. MOC-Buisness (add 1000000): 8

A simple update stmt will do!

7 comments:

q8Honey said...

Yeah that helps a lot.. thanks ;*

doona said...

i hate them for doing this :(

Hottie said...

I don't get it :S

PaLoMiNo said...

Thanks 7abebti ;*

Nemo said...

q8honey and palomino:
u're most welcome :):):)

dandoon:
Me tooooooooooooooooo

hottie:
this is what i did at work to convert all phone numbers in the DB (~ 15,000 records) :)

Journal Entries said...

thaanx this was very helpful!
ma kint a3arif il 7 oo mushtaqat'ha 7ag zain wila wa6aniya

Nemo said...

u're most welcome :)