Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

RE: Deleting Part of Field

Discussion in 'Information Technology' started by Ofer, Nov 10, 2005.

  1. Ofer

    Ofer
    Expand Collapse
    Guest

    First, you don't have to delete it, you can use a select query to return the
    right data

    SELECT Mid([FieldName],InStr([FieldName],"/")+1) AS NewField
    FROM TableName

    But, if you want to update the field, first back up

    UPDATE TableName SET TableName.FieldName = Mid([FieldName ],InStr([FieldName
    ],"/")+1)

    --
    The next line is only relevant to Microsoft''s web-based interface users.
    If I answered your question, please mark it as an answer. It''s useful to
    know that my answer was helpful
    HTH, good luck


    "GOL" wrote:

    > I have fields that look like this: kkkk/5
    > jjjj/556
    >
    > I want to delete everything to the left of the /, leaving /5 and /556 only.
    >
    > Help please.
     
  2. Loading...

    Similar Threads Forum Date
    Sikh News Is Mahesh Bhatt considering deleting Meera's controversial kissing ... Breaking News Mar 4, 2005
    Sikh News US Lawmakers Partake In Sikh Tradition Of 'Langar' On Capitol Hill - Asian Fortune Breaking News Jul 23, 2016
    Sikh Gurus Sikh History Vol 2, Guru Nanak Sahib (Part B) History of Sikhism Jun 26, 2016
    Sikh Gurus Sikh History, Vol 1: Guru Nanak Sahib (Part A) History of Sikhism Jun 26, 2016
    Sikhism Sikhism In Iran – A Part Of Cultural Diaspora Sikh Sikhi Sikhism May 18, 2016

Share This Page