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

    Expand Collapse

    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

    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...

Since you're here... we have a small favor to ask...     Become a Supporter      ::     Make a Contribution     

Share This Page