Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2003
    Location
    canada
    Posts
    230

    Unanswered: Is there any function or any way for searching specified word in a text column in db2

    Hi All,
    I am using db2 v8 fixpac 5 Aix 5.2,
    Could you please help me How can I find specified word from a column(in a table) with type varchar(3000) contains string ?

    Thank you in advance for your help

  2. #2
    Join Date
    Oct 2003
    Location
    Rome
    Posts
    15
    LIKE '%string%'

  3. #3
    Join Date
    Sep 2003
    Location
    canada
    Posts
    230
    Quote Originally Posted by gdipietro80
    LIKE '%string%'
    Oh, right!! thank you so much

Posting Permissions

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