Using characters in LIKE for string

[daveMo]

Hey guys,

i know that this works:

bool = "*abc*" like "xabcx" 'true

dim a as string, b as string
a =  "abc"
b =  xxxacbxxx"

if True = a like b then
    '...
end if

Is it possible to use characters like * ? # in the second code:

if True = *a* like b then 'I know, that does not work

I hope you get what I mean. Or are there even better functions to solve the problem?

Thanks in advance.

 

[Comfy]

Yes but you would have to do:

If "*" & a & "*" like b Then

 

[daveMo]

thanks, for the help! Works fine

Sub test1()
Dim a As String, b As String


a = "abc"
b = "xabcx"
      If b Like "*" & a & "*" = True Then
      MsgBox ("T")
      Else: MsgBox ("F")
End If


End Sub