Is VBscript ever case sensitive?

[Rob]

Are there any situations where VBscript is case sensitive?

I realize that in general it's not, but are there any exceptions?

i.e.: -When referencing database fields or their contents.
-when referring to certain objects, variables, etc.

if not, can I make a case-sensitive comparison between a VBscript variable
and the contents of a Database field (ie: checking a case sensitive
password)?

Thanks in advance for your help and patience with my newbie questions.

rob-ki...@usa.net

[John Timney (MVP)]

I have not come across any situations where Vbscript is case sensistive..

John Timney (MVP)

[Sridhar Krishnan]

On Mon, 30 Nov 1998, John Timney (MVP) wrote:

> I have not come across any situations where Vbscript is case sensistive..
>
> John Timney (MVP)
>
>
> >I realize that in general it's not, but are there any exceptions?
> >
> >i.e.: -When referencing database fields or their contents.

The contents can be case-sensitive - depends on the database. Oracle, SQL
Server (AFAIK), Sybase all store values that are case-sensitive. The
system objects (like table names, column names) probably are not.

> > -when referring to certain objects, variables, etc.

If you are using file names, they could be case-sensitive on NT.

> >
> >if not, can I make a case-sensitive comparison between a VBscript variable
> >and the contents of a Database field (ie: checking a case sensitive
> >password)?

probably convert the string to ascii values to compare. However, checking
database values may not require this case-sensitive check because most
major SQL databases support case-sensitive values.