RE: [sqr-users] criteria on LONG datatypes

["Atluri, Sreenivas S109" <Sreenivas.Atluri@CIGNA.COM>]

You can use "Instring"  command in SQR

Sreeni.

> -----Original Message-----
> From: George Jansen [SMTP:GJANSEN@aflcio.org]
> Sent: Friday, January 24, 2003 2:23 PM
> To:   sqr-users@sqrug.org
> Subject:      Re: [sqr-users] criteria on LONG datatypes
> 
> 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

------------------------------------------------------------------------------
CONFIDENTIALITY NOTICE: If you have received this e-mail in error, please 
immediately notify the sender by e-mail at the address shown.  This e-mail 
transmission may contain confidential information.  This information is 
intended only for the use of the individual(s) or entity to whom it is intended 
even if addressed incorrectly.  Please delete it from your files if you are not 
the intended recipient.  Thank you for your compliance. Copyright (c) 2003 CIGNA

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

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