Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2002
    Posts
    173

    Unanswered: case sensitive search - not sure why

    This is the sql I'm using

    SELECT tbl3.col1, tbl3.col2, tbl3.col3, tbl3.col4, tbl3.col5, tbl3.col6, tbl3.col7, tbl3.col17, substring(tbl3.col17
    FROM 1 for 8)||'-'||substring(tbl3.col17 from 9 for 3) as col17formatted, tbl3.col18, substring(tbl3.col18 from 1 for 2)||'-'||substring(tbl3.col18 from 3 for 7) as col18formatted, tbl3.col19 FROM tbl3 LEFT JOIN tbl4view ON tbl3.col1 = tbl4view.col13
    WHERE (tbl3.col2 Like '%a99%' or tbl3.col3 Like '%a99%' or tbl3.col7 Like '%a99%' or tbl3.col4 Like '%a99%' or tbl3.col5 Like '%a99%' or tbl3.col17 Like '%a99%' or tbl3.col18 Like '%a99%'or tbl3.col19 Like '%a99%')
    ORDER BY tbl3.col2 ASC

    For some reason the search is case sensitive. Is there a way to remove the sensitivity in the search words that query receives? Setupostgresql,php4,iis,w2k server

  2. #2
    Join Date
    Apr 2003
    Posts
    23
    like IS case sensitive
    ilike ISN'T.

  3. #3
    Join Date
    Jun 2002
    Posts
    173
    Thanks! Works great now!

Posting Permissions

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