|
 |
asp_databases thread: Uppercase/lowercase Queries
Message #1 by Craig Flannigan <ckf@k...> on Mon, 23 Apr 01 08:39:27 BST
|
|
Could you help me with a database problem please?
I have set up an ACCESS file to analyse Sales data downloaded from
our main system. My problem is that we have some fields that contain
single letter codes which include upper and lower case characters -
with different meanings. As you know, ACCESS queries do not
normally differentiate between upper and lower case.
Is there an SQL (or other) solution to force the query to
differentiate case?
Many thanks.
Craig.
_____________________________________________________
Craig Flannigan
Development Supervisor - Business Systems
Kaye House
Tel: 0114 256 6070
Email: ckf@k...
Message #2 by "Charles Feduke" <webmaster@r...> on Mon, 23 Apr 2001 20:59:44 -0400
|
|
I'm sure someone has beat me to this, but you can always use VBA functions
such as LCase or UCase:
SELECT * FROM table WHERE UCase(code) = UCase(code)
In fact I think if you use LIKE it does not do binary equivalency (sp?);
just guessing at that though.
- Chuck
----- Original Message -----
From: "Craig Flannigan" <ckf@k...>
To: "ASP Databases" <asp_databases@p...>
Sent: Monday, April 23, 2001 4:39 AM
Subject: [asp_databases] Uppercase/lowercase Queries
> Could you help me with a database problem please?
>
> I have set up an ACCESS file to analyse Sales data downloaded from
> our main system. My problem is that we have some fields that contain
> single letter codes which include upper and lower case characters -
> with different meanings. As you know, ACCESS queries do not
> normally differentiate between upper and lower case.
>
> Is there an SQL (or other) solution to force the query to
> differentiate case?
>
>
> Many thanks.
>
> Craig.
Message #3 by "Dallas Martin" <dmartin@z...> on Mon, 23 Apr 2001 22:07:41 -0400
|
|
Not In SQL70.
User Upper() and Lower() instead of Ucase() and Lcase().
Dallas
----- Original Message -----
From: "Charles Feduke" <webmaster@r...>
To: "ASP Databases" <asp_databases@p...>
Sent: Monday, April 23, 2001 8:59 PM
Subject: [asp_databases] Re: Uppercase/lowercase Queries
> I'm sure someone has beat me to this, but you can always use VBA
functions
> such as LCase or UCase:
>
> SELECT * FROM table WHERE UCase(code) = UCase(code)
>
> In fact I think if you use LIKE it does not do binary equivalency
(sp?);
> just guessing at that though.
>
> - Chuck
>
> ----- Original Message -----
> From: "Craig Flannigan" <ckf@k...>
> To: "ASP Databases" <asp_databases@p...>
> Sent: Monday, April 23, 2001 4:39 AM
> Subject: [asp_databases] Uppercase/lowercase Queries
>
>
> > Could you help me with a database problem please?
> >
> > I have set up an ACCESS file to analyse Sales data downloaded from
> > our main system. My problem is that we have some fields that contain
> > single letter codes which include upper and lower case characters -
> > with different meanings. As you know, ACCESS queries do not
> > normally differentiate between upper and lower case.
> >
> > Is there an SQL (or other) solution to force the query to
> > differentiate case?
> >
> >
> > Many thanks.
> >
> > Craig.
Message #4 by "Charles Feduke" <webmaster@r...> on Tue, 24 Apr 2001 15:29:54 -0400
|
|
> Not In SQL70.
>
> User Upper() and Lower() instead of Ucase() and Lcase().
Oops, just saw ACCESS and stopped reading.
- Chuck
----- Original Message -----
From: "Dallas Martin" <dmartin@z...>
To: "ASP Databases" <asp_databases@p...>
Sent: Monday, April 23, 2001 10:07 PM
Subject: [asp_databases] Re: Uppercase/lowercase Queries
> Not In SQL70.
>
> User Upper() and Lower() instead of Ucase() and Lcase().
>
> Dallas
>
>
>
> ----- Original Message -----
> From: "Charles Feduke" <webmaster@r...>
> To: "ASP Databases" <asp_databases@p...>
> Sent: Monday, April 23, 2001 8:59 PM
> Subject: [asp_databases] Re: Uppercase/lowercase Queries
>
>
> > I'm sure someone has beat me to this, but you can always use VBA
> functions
> > such as LCase or UCase:
> >
> > SELECT * FROM table WHERE UCase(code) = UCase(code)
> >
> > In fact I think if you use LIKE it does not do binary equivalency
> (sp?);
> > just guessing at that though.
> >
> > - Chuck
> >
> > ----- Original Message -----
> > From: "Craig Flannigan" <ckf@k...>
> > To: "ASP Databases" <asp_databases@p...>
> > Sent: Monday, April 23, 2001 4:39 AM
> > Subject: [asp_databases] Uppercase/lowercase Queries
> >
> >
> > > Could you help me with a database problem please?
> > >
> > > I have set up an ACCESS file to analyse Sales data downloaded from
> > > our main system. My problem is that we have some fields that contain
> > > single letter codes which include upper and lower case characters -
> > > with different meanings. As you know, ACCESS queries do not
> > > normally differentiate between upper and lower case.
> > >
> > > Is there an SQL (or other) solution to force the query to
> > > differentiate case?
> > >
> > >
> > > Many thanks.
> > >
> > > Craig.
>
>
|
|
|
View Cart
