Upper Case

Results 1 to 2 of 2

Thread: Upper Case

  1. #1
    Join Date
    Dec 1969

    Default Upper Case

    I want to do a comparison - when a authenticated user is making an addition to a table I want to ensure that the primary key value entered in the text field does not already exist. I want for example "HELLO" to be seen as the same thing as "hello". At the moment the validation will work for an exact match but sees a lower case entry as different to an upper case entry and submits the form - leaving the user with an ugly database error message. Everything is entered into the database in upper case, so if I could transform the value in the text field to uppercase before doing the comparison maybe it would solve the problem - how can I do this??

  2. #2
    Join Date
    Dec 1969

    Default RE: Upper Case

    Ucase(string)<BR>But you should also cheack the StrComp funcion. See Details at:<BR><BR>http://www.devguru.com/Technologies/vbscript/quickref/strcomp.html<BR><BR>read there about the Binary comparison and the Text comparison...<BR><BR>Ran

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts