Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2009
    Posts
    14

    Unanswered: partial retrieval of data

    is there a way to retrieve the value of a cell partially based on the delimiters within the data.. ?


    For example if my cell has a value like

    abc.123#myvalue@xyz

    i only need the value before the @ symbol(my desired output is not the entire value of the cell, only abc.123#myvalue,)
    Vikram RM

  2. #2
    Join Date
    May 2005
    Location
    South Africa
    Posts
    1,365
    Provided Answers: 1
    Assuming you refer to an ASE column
    Use a combination of charindex and substring

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •