Encrypted table and SQL comands

[alexhaifa]

Hello

Having all my table encrypted, I'd like to know if it is possible to use the SQL comands normally? Like this:

SELECT * FROM TABLE
WHERE NAMEPROD LIKE '%XYZ%'

Thanks
Alexandre

[ViktorV]

Firebird server doesn't provide capabilities for data search in encrypted fields. Search by encrypted fields is available only on the client side after decrypting data using the Locate and LocateEx methods.