Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Case query
Hi all,
I want to have a password but i need the word not to be case sensitive. How do I achieve this? Thanks Greg B |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Case query
Store your (encrypted, hopefully) passwords in lower case, use the LCase
function on the inputted password and compare it to the stored lower case passwords. Rick "Greg B" <littlelap(no wrote in message ... Hi all, I want to have a password but i need the word not to be case sensitive. How do I achieve this? Thanks Greg B |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Case query
thankyou I didnt think of the easy way to do it.Just making it too
complicated for myself. Thanks for the advice Greg "Rick Rothstein (MVP - VB)" wrote in message ... Store your (encrypted, hopefully) passwords in lower case, use the LCase function on the inputted password and compare it to the stored lower case passwords. Rick "Greg B" <littlelap(no wrote in message ... Hi all, I want to have a password but i need the word not to be case sensitive. How do I achieve this? Thanks Greg B |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 case sensitive problems with New Database Query | Excel Discussion (Misc queries) | |||
MS database query: Statement CASE WHEN THEN ELSE END | Excel Programming | |||
Excel query of Postgress database - schema case problem.. | Excel Discussion (Misc queries) | |||
Select Case Query?? | Excel Programming | |||
Change the text from lower case to upper case in an Excel work boo | Excel Discussion (Misc queries) |