Search for a wildcard

[sdb0812]

Is there any way you can search a particular field in a table and find a wildcard? In my case, there are records that begin the the character "*" and I need to find them all. Everything I have tried thus far is using the "*" as a wildcard and is not searching for the literal "*".

Can this be done, and if so....how?

thanks,
sdb0812

 

[cmmrfrds]

Try enclosing the wildcard character in brackets for certain types of searches or use a function like instr.

instr(myfield,"[*]&quot > 0

Did you try

instr(myfield,"*&quot > 0

 

[sdb0812]

cmmrfrds,

I tried using the instr function but it wouldn't work with the "*". I tried another character that is in my data, which is the "(" and it was found, but the "*" is still eluding me.

 

[cmmrfrds]

I tried this simple test and it found the * in position 4.


Dim var As String, int1 as integer
var = "sss*aaa"
int1 = InStr(1, var, "*", vbTextCompare)
Debug.Print "instr compare = "; int1

 

[sdb0812]

It worked like a champion including the start position. Thank you...I didn't think this would ever work!!

hats off and giving props to cmmrfrds

sdb0812

 

[judgehopkins]

cmmrfrds

I posted thread220-587983 but have not gotten any answers.

Care to take a stab at it?

Thanks! (either way....)

"The potentialities of a language are so vast that we must wonder sometimes at ourselves: how do we manage to know so much?" Anthony Burgess, A Mouthful of Air