Re: [sqr-users] criteria on LONG datatypes

["George Jansen" <GJANSEN@aflcio.org>]

If you are using Oracle, you'll want to use what is now called the
interMedia Text option. Basically, you pre-build special indexes on such
fields, and can then use queries like

SELECT a
FROM b
WHERE contains(c, 'some string', 1) > 0

There is plenty of documentation available on this. A good place to
start would be Technet, otn.oracle.com.


>>> lakef250@yahoo.com 01/24/03 01:20PM >>>

Does anyone know how I can search for a string in a LONG datatype?  

Thanks in advance.



---------------------------------
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org 
http://www.sqrug.org/mailman/listinfo/sqr-users

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users