Anyone here familiar with using CATSEARCH type oracle queries? If so, I am
trying to do something like:
SELECT COLNAME
FROM MYTABLE
WHERE CATSEARCH(MYFIELD,'motor',NULL) > 0
OR SHORT_DESCRIPTION LIKE '%motor%'
The problem is I get an oracle error about functional invocation; however I
and use an AND in my where clause and no errors occur. Thanks for any help
anyone can provide.
_______________________________________________________
Chris Cranford
Programmer/Developer
SETECH Inc. & Companies
6302 Fairview Rd, Suite 201
Charlotte, NC 28210
Phone: (704) 362-9423, Fax: (704) 362-9409, Mobile: (704) 650-1042
Email: [EMAIL PROTECTED]
