It sounds to me like maybe you are saying you want to match more than one pattern in the data, where the common factor is that it's palindromic?
I have done very little pattern matching with sql and stay away from ms access, but maybe this is the direction to look in...
Quote:
Reverse a String
Access: SELECT STRREVERSE(StringVal)
T-SQL: SELECT REVERSE(StringVal)
|
I mean... if it's palindromes you want to match, then you could be a clever lad and test to see if the reversed string is the same as the original string... however, maybe you'll have to go through all the data and check for the match, rather than just 'selecting' matching data - I dunno much about it, but the reverse-a-string concept would blatantly be a show-off way to get it done, assuming I understood what you were asking.
IF i had to do it, I'd be using perl, and i dunno if there's any string-reverse functions in perl (although i'll probably check it out one day)
so i'd actually go through each item, break it up into characters, and perform a multitude of tests - almost as complicated as trying to write it in C - but i expect there's a reverse-string option in c too! |
