DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Breaking string

  1. 03-21-2003, 03:27 AM #1
    soniaarora
    soniaarora is offline Member
    Join Date
    Jul 2002
    Posts
    132

    Breaking string

    Hi,

    Can someone help me out.
    I have a string like this abc#def#hij#klo coming in as a parameter.
    Now I need to break this string with delimiter as # and have them in the where condition like
    where col in ('abc','def','hij','klo')
    Pl. note that this string can have any number of sub-strings like this delimited by #.
    How do I do this?

    Regards
    Sonia
    Reply With Quote Reply With Quote
  2. 03-21-2003, 05:42 AM #2
    DaPi's Avatar
    DaPi
    DaPi is offline Old Cranky Philosopher
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    WHERE INSTR(input_string||'#', col||'#') <> 0
    should work, but won't be efficient (can't use an index on col).
    "The power of instruction is seldom of much efficacy except in those happy dispositions where it is almost superfluous" - Gibbon, quoted by R.P.Feynman
    Reply With Quote Reply With Quote
  3. 03-25-2003, 05:28 AM #3
    DaPi's Avatar
    DaPi
    DaPi is offline Old Cranky Philosopher
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    WHERE INSTR('#'||input_string||'#', '#'||col||'#') <> 0
    would be even nicer - it should deal with variable length substrings.
    "The power of instruction is seldom of much efficacy except in those happy dispositions where it is almost superfluous" - Gibbon, quoted by R.P.Feynman
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width