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?
MS Access problem
Moderator: Thanas
MS Access problem
"This is supposed to be a happy occasion... Let's not bicker and argue about who killed who."
-- The King of Swamp Castle, Monty Python and the Holy Grail
"Nothing of consequence happened today. " -- Diary of King George III, July 4, 1776
"This is not bad; this is a conspiracy to remove happiness from existence. It seeks to wrap its hedgehog hand around the still beating heart of the personification of good and squeeze until it is stilled."
-- Chuck Sonnenburg on Voyager's "Elogium"
-- The King of Swamp Castle, Monty Python and the Holy Grail
"Nothing of consequence happened today. " -- Diary of King George III, July 4, 1776
"This is not bad; this is a conspiracy to remove happiness from existence. It seeks to wrap its hedgehog hand around the still beating heart of the personification of good and squeeze until it is stilled."
-- Chuck Sonnenburg on Voyager's "Elogium"