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

    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


    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
    South Africa
    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