Case Problems.

Results 1 to 2 of 2

Thread: Case Problems.

  1. #1
    Join Date
    Dec 1969

    Default Case Problems.

    Hi Guys,<BR><BR>I have a form, user enters details and then SQL statement searches SQL database for results.<BR><BR>I use a LIKE search.<BR><BR>If a user entered COOKE, cooke, cOoKe, etc no record if found. But if a user enters Cooke it finds the record or Cooke. How can I get my script to not be prejeduce and search for all case values?<BR><BR>Thanks guys!<BR>Renee :o)

  2. #2
    Join Date
    Dec 1969

    Default RE: Case Problems.

    This has nothing to do with your sql. You have to set up case (in)sensitivity in the database itself. What dbms are you using?

Posting Permissions

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