1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

how to form a query

Discussion in 'General' started by sriram_gc, Dec 28, 2010.

Thread Status:
Not open for further replies.
  1. sriram_gc

    sriram_gc Active Member

    Messages:
    4
    Likes Received:
    1
    Trophy Points:
    65
    i have one table as contact with three column one is email1, second is email two , third is phone no these are the three columns.
    in that 2 email fields ,i want to select the fileds which is not contanined '@' . and i want to change these field contents as 'invalid email' . how to form the query.
     
    mdilyas likes this.
  2. Sadik

    Sadik Community Moderator Forum Guru

    Messages:
    1,906
    Likes Received:
    252
    Trophy Points:
    1,455
    Please do not double post, you already have a thread here
     
Thread Status:
Not open for further replies.