case-sensitivity (ASP VB)

[stewboy webforumsuser@macromedia.com]

My database is case-sensitive, so when a user inputs geg instead of GEG, it doesn't recognize. I tried putting LIKE instead of = in the SQL, but that makes no difference.

Is there a way to set the parameters of my form variable so the input is Upper Case only?

[jon spivey]

Hi,

strTemp = ucase(request.form("fieldname"))

Jon

"stewboy" <webforumsuser@macromedia.com> wrote in message
news:bf9l9q$c0v$1@forums.macromedia.com...

> My database is case-sensitive, so when a user inputs geg instead of GEG,

it doesn't recognize. I tried putting LIKE instead of = in the SQL, but that
makes no difference.

>
> Is there a way to set the parameters of my form variable so the input is

Upper Case only?

>
>

[Ed]

change your SQL statement to check for uppercase

....
Where Upper( field1 ) = Upper ( parameter )

On Fri, 18 Jul 2003 20:28:42 +0000 (UTC), "stewboy"
[email]webforumsuser@macromedia.com[/email] wrote:

>My database is case-sensitive, so when a user inputs geg instead of GEG, it doesn't recognize. I tried putting LIKE instead of = in the SQL, but that makes no difference.
>
>Is there a way to set the parameters of my form variable so the input is Upper Case only?
>
>