max position of a char in string
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: max position of a char in string

  1. #1
    Join Date
    Sep 2001
    Location
    UK
    Posts
    45

    max position of a char in string

    Hi,

    How do I get max position of a character in a string
    for eg.

    If the string has the value

    ('find value of the variable ')

    I want to know the position of the char 'e' of the word variable
    Basically all characters after this point will be spaces (ascii 32)
    till end of string .

  2. #2
    Join Date
    Nov 2004
    Location
    Mumbai, India
    Posts
    452
    select instr('find value of the variable','e',-1) from dual
    There are three kinds of lies: Lies, damned lies, and benchmarks...

    Unix is user friendly. It's just very particular about who it's friends are.

    Oracle DBA

Posting Permissions

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



Click Here to Expand Forum to Full Width