Try "CONTAINS". You will need to install intermedia, create preferences and index those LONG columns. Oracle*Intermedia is not free software, it has to be purchased. If you don't want to purchase Intermedia, you can convert LONG columns into BFILE and use egrep or perl. Good luck with that. -- Mladen Gogala A & E TV Network Ext. 1216 > -----Original Message----- > From: Sami Seerangan [mailto:dba.orcl@xxxxxxxxx] > Sent: Tuesday, October 26, 2004 2:42 PM > To: Oracle Discussion List > Subject: How to search on LONG datatype column > > > Hi All, > > I want to search something based on search_condition. Since > search_condition column is LONG data type I could not use > "like" or "=" operator. -- //www.freelists.org/webpage/oracle-l