[AccessD] instr() - Need an exact match

John Skolits askolits at ot.com
Thu Sep 11 14:53:36 CDT 2003


Is there a way to do an exact match with something like Instr(). I don't
want a partial match.

For example:
I have a string:    "SecGrp_Admin, SecGrp_Eng, SecGro_User"

I want to look see if "SecGrpAdmin_Super" is in the string. Instr() will
return a value but I want an exact match.

I know I can parse the string and look for an exact match based on the
parsed value. I just thought maybe there's a function I can use that would
do an Exact match test.

John Skolits






More information about the AccessD mailing list