case-sensitivity (ASP VB)

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?

Hi,

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

Jon

"stewboy" <webforumsuser (AT) macromedia (DOT) com> 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?

change your SQL statement to check for uppercase

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

On Fri, 18 Jul 2003 20:28:42 +0000 (UTC), "stewboy"
webforumsuser (AT) macromedia (DOT) com 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?