> > I can search on encrypted uppercase to encrypted uppercase so that
> >it's case-less. I'd have a Notes_U field in this case.
>
> One way around it, kicking myself for not seeing that :-)
> Note you won't be able to use the '%' string operator though, because
> 'ABFOODE' will still encrypt (very) different to 'DEFOOAB', and so a
> search
> for encrpyt('FOO') will fail.
Really? They won't both have the same encryption for the FOO part of the word?
I'm using the same key.
Gosh, this is something else.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four
times a year.
http://www.fusionauthority.com/quarterly
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:259025
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
