Results 1 to 3 of 3

Thread: SQL Question

  1. #1

    Thread Starter
    Fanatic Member
    Join Date
    May 2004
    Location
    Granby, Qc, Canada
    Posts
    602

    SQL Question

    How can I do a difference between lower case and upper case in a SQL statement in a Microsoft Access XP database ?

  2. #2
    I'm about to be a PowerPoster! Hack's Avatar
    Join Date
    Aug 2001
    Location
    Searching for mendhak
    Posts
    58,335

    Re: SQL Question

    Use LCase or UCase to convert it to all the same case.

  3. #3
    Shared Member
    Join Date
    May 2005
    Location
    Kashmir, India
    Posts
    2,277

    Re: SQL Question

    Access is normally case-insensitive, however this might help
    http://support.microsoft.com/?kbid=209674
    Use [code] source code here[/code] tags when you post source code.

    My Articles

Posting Permissions

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



Click Here to Expand Forum to Full Width