Professional Web Applications Themes

sql query to do non-case sensitive search for text? - IBM DB2

record1[fieldA] = "blahblahBLEHBLEH" record2[fieldA] = "BLAHBLAHblehbleh" How do I construct an SQL query that will returns both record? ie. treat it as non-case sensitive? This is so newbie that I am embarrased to ask, but I just can't remembr how to do it, since I don't use SQL all that often. Some kind person please help. select * from mytable where fieldA like '%blahbleh%' and it should return me both record1 and record2 please...

  1. #1

    Default sql query to do non-case sensitive search for text?

    record1[fieldA] = "blahblahBLEHBLEH"
    record2[fieldA] = "BLAHBLAHblehbleh"

    How do I construct an SQL query that will returns both record? ie.
    treat it as non-case sensitive? This is so newbie that I am
    embarrased to ask, but I just can't remembr how to do it, since I
    don't use SQL all that often. Some kind person please help.

    select * from mytable where fieldA like '%blahbleh%'

    and it should return me both record1 and record2 please
    Kenjis Kaan Guest

  2. #2

    Default Re: sql query to do non-case sensitive search for text?

    Find around those :

    [url]http://groups.google.ca/groups?hl=en&lr=&ie=ISO-8859-1&scoring=d&q=insensitive+AND+group%3Acomp.databas es.ibm-db2[/url]

    PM


    PM \(pm3iinc-nospam\) Guest

  3. #3

    Default Re: sql query to do non-case sensitive search for text?

    Kenjis Kaan <tivolinewbiecanada.com> wrote:
    > record1[fieldA] = "blahblahBLEHBLEH"
    > record2[fieldA] = "BLAHBLAHblehbleh"
    >
    > How do I construct an SQL query that will returns both record? ie.
    > treat it as non-case sensitive? This is so newbie that I am
    > embarrased to ask, but I just can't remembr how to do it, since I
    > don't use SQL all that often. Some kind person please help.
    >
    > select * from mytable where fieldA like '%blahbleh%'
    >
    > and it should return me both record1 and record2 please
    select * from mytable where LOWER(fieldA) like '%blahbleh%'

    --
    Knut Stolze
    Information Integration
    IBM Germany / University of Jena
    Knut Stolze Guest

Similar Threads

  1. SQL 92 - case sensitive
    By rabaaoui abdelhak in forum MySQL
    Replies: 1
    Last Post: February 28th, 05:49 PM
  2. #23026 [Com]: Make Zend case-sensitive (classes, functions, remove case-insensitive)
    By nvivo at mandic dot com dot br in forum PHP Development
    Replies: 0
    Last Post: October 19th, 12:17 PM
  3. Case Sensitive
    By amit in forum Microsoft SQL / MS SQL Server
    Replies: 4
    Last Post: July 31st, 12:32 PM
  4. Glob() is Case Sensitive
    By Krhis in forum PHP Development
    Replies: 1
    Last Post: July 26th, 04:30 AM
  5. getPos is case sensitive
    By Lingo Dude in forum Macromedia Director Lingo
    Replies: 9
    Last Post: July 17th, 05:29 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139