Ok, I will ask the question everyone else seems to be afraid to ask....
What is this data (obviously, don't tell us anything secret, just a vague understanding like it's personal medical info or maybe the datatype...) you are trying to search on and why is it encrypted? Generally speaking, I only encrypt data I don't want virtually anyone getting their hands on, like SSNs and CC numbers. These are things I would never let anyone, including myself have a blind "like" search on. They are generally only pieces of info to be used in a very specific context on a person by person basis. Also, how large is the databse you are searching, if the datset is small enough you could in theory select * and decrypt the data and then Query of Queries on the decrypted data. Don't do this if it's a large recordset, the performance issues would be massive. -- Alan Rother Adobe Certified Advanced ColdFusion MX 7 Developer ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:258860 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
