Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2014
    Posts
    35

    Unanswered: Input mask for field

    I have a database recording someones data and part of it is the UK national insurance number which is of the format AA999999A - ie two capitals, 6 numbers and a capital.

    I can mask the input to require the format except for the capitals when it will accept capitals or lower case.

    Does anyone know how I can make it require upper case or (better still, change lower case input to upper case).

    Many thanks

  2. #2
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    The Upper() function converts text to uppercase.
    George
    Home | Blog

  3. #3
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    isn't this a requirement of the front end
    I guess you could write a stored procedure or trigger to enforce this.

    what are you using to t capture the data
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

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