Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004
    Posts
    3

    Unanswered: Comparing lowercase fields to lowercase values

    Hi,

    I was wondering if it is possible to convert a field to lower case.

    For example:

    SELECT title FROM mytable WHERE LCASE(title)='lower case str';

    Cheers

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Should work swell using Lower().

    -PatP

Posting Permissions

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