access not case sensitive?

am 11.10.2006 21:58:39 von hempguy

i have an asp page with a form that takes an email address and writes it to
an access DB. if i enter someone@somewhere.com and on a different page
SELECT email addresses that equal SOMEONE@SOMEWHERE.COM, my results are
returned. i was expecting this query to not return anything because the case
is different. can anyone shed some light here?

Re: access not case sensitive?

am 11.10.2006 22:08:33 von reb01501

hempguy wrote:
> i have an asp page with a form that takes an email address and writes
> it to an access DB. if i enter someone@somewhere.com and on a
> different page SELECT email addresses that equal
> SOMEONE@SOMEWHERE.COM, my results are returned. i was expecting this
> query to not return anything because the case is different. can
> anyone shed some light here?

JetSQL is not case-sensitive. You can do case-sensitive searches by
using the VBA strComp() function (I think this is one of the allowed
functions ...), but why would you in this instance? Email addresses
aren't case-sensitive either, are they?

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

Re: access not case sensitive?

am 11.10.2006 22:32:45 von hempguy

"Bob Barrows [MVP]" wrote in message
news:%23qtOJEX7GHA.3960@TK2MSFTNGP05.phx.gbl...
> hempguy wrote:
>> i have an asp page with a form that takes an email address and writes
>> it to an access DB. if i enter someone@somewhere.com and on a
>> different page SELECT email addresses that equal
>> SOMEONE@SOMEWHERE.COM, my results are returned. i was expecting this
>> query to not return anything because the case is different. can
>> anyone shed some light here?
>
> JetSQL is not case-sensitive. You can do case-sensitive searches by
> using the VBA strComp() function (I think this is one of the allowed
> functions ...), but why would you in this instance? Email addresses
> aren't case-sensitive either, are they?
>
> --
> Microsoft MVP -- ASP/ASP.NET
> Please reply to the newsgroup. The email account listed in my From
> header is my spam trap, so I don't check it very often. You will get a
> quicker response by posting to the newsgroup.
>
>

no no ... i was just thinking that if someone enters a lowercase email
address, and i later search for that email address but type in caps, i need
to make sure ill always find the match. so should i do a UCase() either
before writing it to the db or perhaps a UCase() before i search? or should
i leave it alone becasue Access wont care either way?

Re: access not case sensitive?

am 11.10.2006 22:40:49 von Mike Brind

"hempguy" wrote in message
news:Ot7ppRX7GHA.1012@TK2MSFTNGP05.phx.gbl...
>
> "Bob Barrows [MVP]" wrote in message
> news:%23qtOJEX7GHA.3960@TK2MSFTNGP05.phx.gbl...
>> hempguy wrote:
>>> i have an asp page with a form that takes an email address and writes
>>> it to an access DB. if i enter someone@somewhere.com and on a
>>> different page SELECT email addresses that equal
>>> SOMEONE@SOMEWHERE.COM, my results are returned. i was expecting this
>>> query to not return anything because the case is different. can
>>> anyone shed some light here?
>>
>> JetSQL is not case-sensitive. You can do case-sensitive searches by
>> using the VBA strComp() function (I think this is one of the allowed
>> functions ...), but why would you in this instance? Email addresses
>> aren't case-sensitive either, are they?
>>
>> --
>> Microsoft MVP -- ASP/ASP.NET
>> Please reply to the newsgroup. The email account listed in my From
>> header is my spam trap, so I don't check it very often. You will get a
>> quicker response by posting to the newsgroup.
>>
>>
>
> no no ... i was just thinking that if someone enters a lowercase email
> address, and i later search for that email address but type in caps, i
> need to make sure ill always find the match. so should i do a UCase()
> either before writing it to the db or perhaps a UCase() before i search?
> or should i leave it alone becasue Access wont care either way?
>

Re: access not case sensitive?

am 11.10.2006 22:47:26 von reb01501

hempguy wrote:
> "Bob Barrows [MVP]" wrote in message
> news:%23qtOJEX7GHA.3960@TK2MSFTNGP05.phx.gbl...
>> hempguy wrote:
>>> i have an asp page with a form that takes an email address and
>>> writes it to an access DB. if i enter someone@somewhere.com and on a
>>> different page SELECT email addresses that equal
>>> SOMEONE@SOMEWHERE.COM, my results are returned. i was expecting this
>>> query to not return anything because the case is different. can
>>> anyone shed some light here?
>>
>> JetSQL is not case-sensitive. You can do case-sensitive searches by
>> using the VBA strComp() function (I think this is one of the allowed
>> functions ...), but why would you in this instance? Email addresses
>> aren't case-sensitive either, are they?
>
> no no ... i was just thinking that if someone enters a lowercase email
> address, and i later search for that email address but type in caps,
> i need to make sure ill always find the match. so should i do a
> UCase() either before writing it to the db or perhaps a UCase()
> before i search? or should i leave it alone becasue Access wont care
> either way?

Just leave it alone because Access won't care either way.

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

Re: access not case sensitive?

am 11.10.2006 22:47:34 von Mike Brind

Re: access not case sensitive?

am 11.10.2006 22:54:23 von hempguy

where do they grow this guy?
he must be God with that attitude

"Mike Brind" wrote in message
news:uG1l3ZX7GHA.2380@TK2MSFTNGP02.phx.gbl...
>
> "hempguy" wrote in message
> news:Ot7ppRX7GHA.1012@TK2MSFTNGP05.phx.gbl...
>>
>> "Bob Barrows [MVP]" wrote in message
>> news:%23qtOJEX7GHA.3960@TK2MSFTNGP05.phx.gbl...
>>> hempguy wrote:
>>>> i have an asp page with a form that takes an email address and writes
>>>> it to an access DB. if i enter someone@somewhere.com and on a
>>>> different page SELECT email addresses that equal
>>>> SOMEONE@SOMEWHERE.COM, my results are returned. i was expecting this
>>>> query to not return anything because the case is different. can
>>>> anyone shed some light here?
>>>
>>> JetSQL is not case-sensitive. You can do case-sensitive searches by
>>> using the VBA strComp() function (I think this is one of the allowed
>>> functions ...), but why would you in this instance? Email addresses
>>> aren't case-sensitive either, are they?
>>>
>>> --
>>> Microsoft MVP -- ASP/ASP.NET
>>> Please reply to the newsgroup. The email account listed in my From
>>> header is my spam trap, so I don't check it very often. You will get a
>>> quicker response by posting to the newsgroup.
>>>
>>>
>>
>> no no ... i was just thinking that if someone enters a lowercase email
>> address, and i later search for that email address but type in caps, i
>> need to make sure ill always find the match. so should i do a UCase()
>> either before writing it to the db or perhaps a UCase() before i search?
>> or should i leave it alone becasue Access wont care either way?
>
> Why would you search with Caps Lock on? Why would you consider defiling
> your data to make it all upper case, rather than turn caps lock off? And
> since JetSQL is not case-sensitive haven't you answered
> your own question?
>
> --
> Mike Brind
>

Re: access not case sensitive?

am 12.10.2006 09:00:05 von Mike Brind

You read an attitude that wasn't intended. I had my tongue in my cheek, but
forgot to put a suitable emoticon in.

--
Mike Brind

"hempguy" wrote in message
news:erD5vdX7GHA.2288@TK2MSFTNGP05.phx.gbl...
> where do they grow this guy?
> he must be God with that attitude
>
>
> "Mike Brind" wrote in message
> news:uG1l3ZX7GHA.2380@TK2MSFTNGP02.phx.gbl...
>>
>> "hempguy" wrote in message
>> news:Ot7ppRX7GHA.1012@TK2MSFTNGP05.phx.gbl...
>>>
>>> "Bob Barrows [MVP]" wrote in message
>>> news:%23qtOJEX7GHA.3960@TK2MSFTNGP05.phx.gbl...
>>>> hempguy wrote:
>>>>> i have an asp page with a form that takes an email address and writes
>>>>> it to an access DB. if i enter someone@somewhere.com and on a
>>>>> different page SELECT email addresses that equal
>>>>> SOMEONE@SOMEWHERE.COM, my results are returned. i was expecting this
>>>>> query to not return anything because the case is different. can
>>>>> anyone shed some light here?
>>>>
>>>> JetSQL is not case-sensitive. You can do case-sensitive searches by
>>>> using the VBA strComp() function (I think this is one of the allowed
>>>> functions ...), but why would you in this instance? Email addresses
>>>> aren't case-sensitive either, are they?
>>>>
>>>> --
>>>> Microsoft MVP -- ASP/ASP.NET
>>>> Please reply to the newsgroup. The email account listed in my From
>>>> header is my spam trap, so I don't check it very often. You will get a
>>>> quicker response by posting to the newsgroup.
>>>>
>>>>
>>>
>>> no no ... i was just thinking that if someone enters a lowercase email
>>> address, and i later search for that email address but type in caps, i
>>> need to make sure ill always find the match. so should i do a UCase()
>>> either before writing it to the db or perhaps a UCase() before i search?
>>> or should i leave it alone becasue Access wont care either way?
>>
>> Why would you search with Caps Lock on? Why would you consider defiling
>> your data to make it all upper case, rather than turn caps lock off? And
>> since JetSQL is not case-sensitive haven't you answered
>> your own question?
>>
>> --
>> Mike Brind
>>
>
>

Re: access not case sensitive?

am 12.10.2006 14:41:05 von hempguy

aahhh...
yes, someone needs to invent a way to show facial expression and body
language in email and ng posts

"Mike Brind" wrote in message
news:ewrxNwc7GHA.1256@TK2MSFTNGP04.phx.gbl...
> You read an attitude that wasn't intended. I had my tongue in my cheek,
> but forgot to put a suitable emoticon in.
>
> --
> Mike Brind
>
>
> "hempguy" wrote in message
> news:erD5vdX7GHA.2288@TK2MSFTNGP05.phx.gbl...
>> where do they grow this guy?
>> he must be God with that attitude
>>
>>
>> "Mike Brind" wrote in message
>> news:uG1l3ZX7GHA.2380@TK2MSFTNGP02.phx.gbl...
>>>
>>> "hempguy" wrote in message
>>> news:Ot7ppRX7GHA.1012@TK2MSFTNGP05.phx.gbl...
>>>>
>>>> "Bob Barrows [MVP]" wrote in message
>>>> news:%23qtOJEX7GHA.3960@TK2MSFTNGP05.phx.gbl...
>>>>> hempguy wrote:
>>>>>> i have an asp page with a form that takes an email address and writes
>>>>>> it to an access DB. if i enter someone@somewhere.com and on a
>>>>>> different page SELECT email addresses that equal
>>>>>> SOMEONE@SOMEWHERE.COM, my results are returned. i was expecting this
>>>>>> query to not return anything because the case is different. can
>>>>>> anyone shed some light here?
>>>>>
>>>>> JetSQL is not case-sensitive. You can do case-sensitive searches by
>>>>> using the VBA strComp() function (I think this is one of the allowed
>>>>> functions ...), but why would you in this instance? Email addresses
>>>>> aren't case-sensitive either, are they?
>>>>>
>>>>> --
>>>>> Microsoft MVP -- ASP/ASP.NET
>>>>> Please reply to the newsgroup. The email account listed in my From
>>>>> header is my spam trap, so I don't check it very often. You will get a
>>>>> quicker response by posting to the newsgroup.
>>>>>
>>>>>
>>>>
>>>> no no ... i was just thinking that if someone enters a lowercase email
>>>> address, and i later search for that email address but type in caps, i
>>>> need to make sure ill always find the match. so should i do a UCase()
>>>> either before writing it to the db or perhaps a UCase() before i
>>>> search? or should i leave it alone becasue Access wont care either way?
>>>
>>> Why would you search with Caps Lock on? Why would you consider defiling
>>> your data to make it all upper case, rather than turn caps lock off?
>>> And since JetSQL is not case-sensitive haven't you
>>> answered your own question?
>>>
>>> --
>>> Mike Brind
>>>
>>
>>
>
>