#1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 18
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 18
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003 case sensitive problems with New Database Query havrek Excel Discussion (Misc queries) 1 March 7th 08 05:17 PM
MS database query: Statement CASE WHEN THEN ELSE END riso Excel Programming 2 March 5th 07 09:31 PM
Excel query of Postgress database - schema case problem.. Frank Brown Excel Discussion (Misc queries) 0 February 12th 07 09:18 PM
Select Case Query?? Don G Excel Programming 1 April 3rd 06 10:42 AM
Change the text from lower case to upper case in an Excel work boo dave01968 Excel Discussion (Misc queries) 2 December 9th 05 09:09 AM


All times are GMT +1. The time now is 09:03 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"