Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2007
    Posts
    1

    Unanswered: Instr SQL function

    I am using Crystal reports and do not recall how to write a sql statement to extract the text in a field that is to the right of the pipe operator.

    Thanks in advance.

  2. #2
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    SELECT SUBSTR(field, INSTR(field, '|') + 1, LENGTH(field))
    FROM ...

Posting Permissions

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