Dear All



I'm really stuck on this one.  I have created a search page in ASP that 

interogates a standard CSV text file for descriptions.  These descriptions are 

about 150 chars tops so there is no problem there.  The problem I have is that 

when I type in keywords into my search interface I can only find these 

descriptions if I put the exact case-ing of the description, eg:



If I put in 'Sil' (without the quotes), it will find the description I am 

looking for.  If I put in 'sil' or 'SIL' it won't.



I am using the standard LIKE command to perform keyword searches in these 

descriptions, but I need a command somewhere that says 'be case insensitive'!



Please note that I don't want to change all of the descriptions to say ucase 

or lcase so that I can force the user's input into the right case, as this 

looks pants!!



Can anybody help???



Regards





Laphan

Try making a function to convert input like "Sil" or "sil" or "SIL" to

"[sS][iI][lL]" and then compare using this string -- if should match any

type of lower and upper case. (See "Using Wildcard Characters in String

Expressions" in Microsoft Access help topics.) Does this work in your case?



Z





----- Original Message -----

From: "laphan" <laphan@u...>

To: "Access ASP" <access_asp@p...>

Sent: Saturday, December 08, 2001 6:46 AM

Subject: [access_asp] RE: Case Insensitive Queries





> Dear All

>

> I'm really stuck on this one.  I have created a search page in ASP that

> interogates a standard CSV text file for descriptions.  These descriptions

are

> about 150 chars tops so there is no problem there.  The problem I have is

that

> when I type in keywords into my search interface I can only find these

> descriptions if I put the exact case-ing of the description, eg:

>

> If I put in 'Sil' (without the quotes), it will find the description I am

> looking for.  If I put in 'sil' or 'SIL' it won't.

>

> I am using the standard LIKE command to perform keyword searches in these

> descriptions, but I need a command somewhere that says 'be case

insensitive'!

>

> Please note that I don't want to change all of the descriptions to say

ucase

> or lcase so that I can force the user's input into the right case, as this

> looks pants!!

>

> Can anybody help???

>

> Regards

>

>

> Laphan

>

>

>




$subst('Email.Unsub').

On your ASP page where the query is built use a command to convert

the input command to all upper case.  This will use any combination

of input and convert to upper case, it stored in Access as upper

case, this works very well and is easy.



Chuck Mabbott



http://aa8vs.dhs.org:81/aa8vs







>From: laphan <laphan@u...>

>Reply-To: "Access ASP" <access_asp@p...>

>To: "Access ASP" <access_asp@p...>

>Subject: [access_asp] RE: Case Insensitive Queries

>Date: Sat, 8 Dec 2001 14:46:37 +0000

>

>Dear All

>

>I'm really stuck on this one.  I have created a search page in ASP that

>interogates a standard CSV text file for descriptions.  These descriptions 

>are

>about 150 chars tops so there is no problem there.  The problem I have is 

>that

>when I type in keywords into my search interface I can only find these

>descriptions if I put the exact case-ing of the description, eg:

>

>If I put in 'Sil' (without the quotes), it will find the description I am

>looking for.  If I put in 'sil' or 'SIL' it won't.

>

>I am using the standard LIKE command to perform keyword searches in these

>descriptions, but I need a command somewhere that says 'be case 

>insensitive'!

>

>Please note that I don't want to change all of the descriptions to say 

>ucase

>or lcase so that I can force the user's input into the right case, as this

>looks pants!!

>

>Can anybody help???

>

>Regards

>

>

>Laphan

>

>

>








_________________________________________________________________

Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp