String Comparison Question.

[zunn]

Hi,

I have 2 string
*************************
dim a as string
dim b as string

a="cat"
b="cat"
***************************
if i want to compare both the string to see whether they are the same.How do i compare ??
isit using
*****************************
if a=b then
msgbox "SAME"
else
msgbox "NOT SAME"
end if
***************************

is my way of doing wrong ?? not is there other way ?? thanks.

[peet]

that will work fine.

your sample is case sensitive. If you want Cat = caT then you can do like this

If UCase(a) = UCase(b) Then
    MsgBox "SAME"
Else
    MsgBox "NOT SAME"
End If

[Chris]

use the StrComp function

Dim a As String
    Dim b As String
    
    a = "cat"
    b = "cAt"
    
    If StrComp(a, b, vbBinaryCompare) = 0 Then
        MsgBox "match"
    Else
        MsgBox "Unmatch"
    End If

if the a dn b is not case sensitive, then compare with vbTextCompare as

Dim a As String
    Dim b As String
    
    a = "cat"
    b = "cat"
    
    If StrComp(a, b, vbTextCompare) = 0 Then
        MsgBox "match"
    Else
        MsgBox "Unmatch"
    End If

[zunn]

OO thanks for all your reply

But, even if my string a is "CAT" and the other is "cat"
by using

if a=b then
msgbox "SAME"
else
msgbox "NOT SAME"
end if

i will get the msgbox "SAME" why ?? is it not case sensitive ??

[Chris]

it will return "NOT SAME"

[zunn]

hmm, can i use "=" to compare 2 string ?? will it be accurate ??

[Chris]

it should be safe