Option Compare

Is the 'option compare' valid in vb.net 2003?

I wish to comapre a text string against a string from my db but some records may not have a capital letter at the front and some may.

I know in VBA I would use option compare to get round this but vb.net seems to disagree with it.

Many Thanks

Scott

You can still use it in 2003 .NET. Place it at the top of your class just like you do for Option Explicit On. Although, are you comparing text from an ADO.NET or ADODB object?

VB Code:

Option Explicit On
Option Strict On
Option Compare Text

Cheers for the quick reply!!!

I sorted it out I placed it abfter the module Module2 rather than before. duh.

ADO.net. is there a better option?

Many Thanks

Scott

You mean is ADODB better then ADO.NET? If so then ADO.NET is best.