1 Reply Latest reply on Aug 3, 2012 8:27 AM by jiyong

    insert statement for to pull lowercase and uppercase in EIM_CONTACT table

      Hi All,

      In my Database i Have First_name and last name @S_CONTACT table following by

      First Name Last Name

      Peter jacson


      I don't want to insert data again with small case or upper case for both column

      Before inserting the data in to table i need to post valdate from table data

      For example,

      i am inserting the data like First Name Last Name

      Peter jacson it has to check database of both column is the data exist in data base with same case or it should be upper case

      then i dont want to insert the data

      Appreciate any one worked on this to avoid duplicate data