StrComp

[azizrasul]

Online help states that if either string1 or string2 is Null, then StrComp returns a Null value. I tried

Option Compare Database

Dim var1 As Variant

var1 = StrComp("ABC", Null)

and I get -1, NOT Null as the online help suggests.

Can anyone explain how I get a Null value from StrComp. If this is not possible, then why not use

Dim var1 As Integer

 

[bat17]

Jus to test, I ran

Sub temp()
Dim var1 As Variant
var1 = StrComp("ABC", Null)
Debug.Print var1
End Sub

in a module in A97 and it returned Null in the Debug Window.

HTH

Peter

 

[azizrasul]

I'm getting Null as well now?? Don't know what I was doing before.

This thing all got started because I was wondering why the return value for StrComp was Variant (Integer). If StrComp can produce Null then why don't we have Variant (String)?

 

[bat17]

It returns an integer -1,0,1 depending on result. Null is a non answer and has no meaning as such. Null is not a string.

Peter

 

[azizrasul]

Thanks Peter. It's all clear now. I've always hated Nulls as I have never really understood them, but I do now from your reply.