MS Access problem
Posted: 2003-11-11 04:48pm
Yeah, yeah... I know... I'm a slave to the evil empire. It's what I've got to work with.
So...
I need to compare a couple of string values to see if they contain the same characters, and I don't know of any function that will do it, so I'm appealing to the techies here.
Here are some examples of what I mean:
"ABCDE" = "ABCDE"
"ABCDE" = "CDEAB"
"ABCDE" <> "ABDEF"
"ABCDE" <> "ABC"
So what I need is a way to compare the characters contained in the string without regard to the order in which they appear. Is there a reasonably easy way to do that?
So...
I need to compare a couple of string values to see if they contain the same characters, and I don't know of any function that will do it, so I'm appealing to the techies here.
Here are some examples of what I mean:
"ABCDE" = "ABCDE"
"ABCDE" = "CDEAB"
"ABCDE" <> "ABDEF"
"ABCDE" <> "ABC"
So what I need is a way to compare the characters contained in the string without regard to the order in which they appear. Is there a reasonably easy way to do that?