I didn't mean for you to pull LIKE2(), but instead to fix it. I don't know if Like() is free of all logical errors either. But that's why I rely on users here to help me test it.
And I didn't mean to make it seem as though I was one-upping you. I just really liked the idea of a single-character wildcard. So if I'm going to update my own code, I might as well re-post it too.
it anyway seems that you are going to improve it still.
btw, if you take a look at the udf-library, there are dublic functions. differences vary from techniques to badly named functions. anyway, as they are expoced, one can always get the best one, right?
#71696 - 2002-11-2703:39 PMRe: In reference to LIKE2 UDF
Crazy EddieCrazy Eddie
Starting to like KiXtart
Registered: 2002-11-20
Posts: 105
Loc: Sacramento, CA USA
No offense taken...truly.
I pulled Like2() because it is not reliable yet. Also, if Like() gets the one remaining issue (INSTR causing some 0 returns when 1 is appropriate) then it is fully functional and should be the UDF of choice.
My logic was getting more and more complicated, attempting to do the whole thing in a single FUNCTION.
I wasn't trying to one-up either. The process for the parsing is a valuable exercise in logic...unfortunately, we found a few examples that really trip up some early assumptions that went into the code. I'm going to try to write-up a flowchart of a correct process.
I do want to contribute here, and I think I have so far. I am impressed with the community. Peers are hard to find in this skill-set!
Best to all, Ed
_________________________
{Insert your favorite Witty Tag Line here}
well, I quess it's matter of crazyness... what more crazy you are, that more you will spend time with your computer kix'ng and that more you will be able to do some crazy stuff.
![[Smile]](images/icons/smile.gif){kind=icon}
The process for the parsing is a valuable exercise in logic...unfortunately, we found a few examples that really trip up some early assumptions that went into the code. I'm going to try to write-up a flowchart of a correct process.![[Wink]](images/icons/wink.gif){kind=icon}
![[Razz]](images/icons/tongue.gif){kind=icon}
![[Big Grin]](images/icons/grin.gif){kind=icon}
