Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2004
    Posts
    33

    Question Unanswered: Crystal Report - Case Sensitive in SQL data

    Hello,

    I have a parameter field and on the select expert I use "start with" {?canineName}. All canine names are stored in upper case chars. When I key in one or a few upper case chars, it works, but not when I key in lower case chars. I have checked "Case-Insensitive in SQL data" in the database tab of the options dialog that I get from the File Menu. Appreciate your help.

  2. #2
    Join Date
    Dec 2004
    Posts
    1
    Try editing the formula to look like this:

    {caninename} startswith UpperCase({?canineName})

Posting Permissions

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