How do I get a Script recogonize both uppercase and lower case letters..?

Sub Main()
If Extract <> "%lookupq1%"
Then
Email2DBSend = True
Else
Email2DBSend = False
End If
End Sub

Here "%lookupq1%" refers to both uppercase letters, how do I make it
recogonize lower case letters??Any advise?

Thanks in advance
Andz

Tim
Wed Aug 16 01:35:59 CDT 2006


Are you asking how to make the comparison case-insensitive ?

Email2DBSend = (UCase(Extract) <> "%LOOKUPQ1%")

Tim


"Andz" <anand411@gmail.com> wrote in message
news:1155708430.538306.163830@m79g2000cwm.googlegroups.com...
> Sub Main()
> If Extract <> "%lookupq1%"
> Then
> Email2DBSend = True
> Else
> Email2DBSend = False
> End If
> End Sub
>
> Here "%lookupq1%" refers to both uppercase letters, how do I make it
> recogonize lower case letters??Any advise?
>
> Thanks in advance
> Andz
>