Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2003
    Posts
    1

    Red face Unanswered: Search keyword !

    Hi Dear All

    I have a problem:
    I want a pl/sql command that do this:

    Select * From tbl1 Where fld1 IN ('%X%', '%Y%', '%Z%', ...)

    fld1 has varchar2 datatype.
    how can i implement this condition in pl/sql ?
    Thanx

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1

    Re: Search keyword !

    Select * From tbl1
    where (fld1 like '%X%' or fld1 like '%Y%' or fld1 like '%Z%' or ... )

Posting Permissions

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