non case specific
As convention I always use Ucase but you could use lcase
if lcase(variable1) = "excluded" then
Chips web link gives you a lot more info on this kind of thing though... You
should take a look at it.
HTH
"mike allen" wrote:
my code reads:
if variable1 = "excluded" then
call abc
else
call def
end if
my problem is 'variable1' is typed in by users and can be 'Excluded',
'EXCLUDED', and other combinations of caps and lower case letters. I want
to include any and all combination of upper and lower case letters, as long
as the spelling is correct. I am sure there is something I can wrap around
'variable1', but I don't know it. Thanks, Mike Allen
|