RE: Text Search

From: Yaocuauhtzin (Yaocuauhtzin_at_discussions.microsoft.com)
Date: 10/07/04

  • Next message: Steve Kass: "Re: SQL 2000 fails to detect NULL values" 
    Date: Thu, 7 Oct 2004 06:17:02 -0700

    Your Database was created with 'case sensitive' option. To change to 'case
    insensitive', you must re-created the Database, I think.

    Also, you can try:

    Select From **** Where upper(****) like upper('****')

    "Ibrahim Awwad" wrote:

    > Dear All,
    > I have table for items, some of the Items codes are including text codes.
    > When I try to use
    > Select From **** Where **** like '****'
    >
    > I don't get the correct record until I put the Upper case or lower case text
    > corrosponding to What's in table.
    > EX. to look for 'DISCOUNT' i can't give him 'discount' I should write it as
    > it's.
    >
    > Is there any solution.
    >
    > --
    > *********
    > IT Manager
    > DeLaval Ltd.
    > Cairo-Egypt
    > *********
    > |-----------------------------|
    > |Islam is peace not Terror|
    > |-----------------------------|

  • Next message: Steve Kass: "Re: SQL 2000 fails to detect NULL values"

    Relevant Pages

    • Re: Preventing double posting to Access database
      ... Grace and Peace to you! ... This problem isn't due to the FrontPage DRW, nor is it related to the ... > The data are stored in an Access database. ...
      (microsoft.public.frontpage.programming)
    • Re: Microcosoft Access
      ... You can have peace. ... Or you can have freedom. ... such as used by WORKS' database. ... > WORD labels uses Access database to create labels. ...
      (microsoft.public.windowsxp.hardware)
    • Re: {OT} spit here
      ... I know mine have been checked against databases, but I don't know if mine have been added to a database. ... Ever applied for a peace officer's job? ... I hold a California Real Estate license, and they took my prints when I applied for the license. ... I had my prints taken for mentoring, soccer and teaching. ...
      (alt.autos.toyota)
    • Re: Getting XP to read Windows 98
      ... create the database on the Win98 one. ... Bruce Chambers ... You can have peace. ... Or you can have freedom. ...
      (microsoft.public.windowsxp.general)