Hi
This query will work...
SELECT * FROM TABLENAME WHERE COLUMN LIKE '%z_%' escape 'z';
ASHOK
Attachments
Library
Quick Reference
Archives
Sample Index
2003 Indexes