ahhhh i suspected as much. i knew sql ddidn't support anything like but i thought there may be a 'hidden' feature of sapdb that could have helped me out ...
never mind... back to the drawing board ... thanks, Steve > -----Original Message----- > From: Zabach, Elke [mailto:[EMAIL PROTECTED]] > Sent: 25 April 2002 12:48 > To: Steve Brett; Sapdb. General@Listserv. Sap. Com (E-mail) > Subject: RE: Search Database ? > > > Steve Brett wrote: > > > Hi all, > > > > We have a sap database we are going to use as a search database. > > > > It is comprised of several tables that are integer based and > > act as pointers > > to lookup tables that contain data definitions. > > > > What we are looking to do is create a fast way of searching > > the database > > from a middle tier written in java. > > > > The search would have to iterate over all values in the > > database and match a > > specific keyword i.e. > > > > the user enters 'David' as the search term and ALL tables in > > the database > > are searched. > > > > Does anyone have any pointers or experience in this kind of search ? > > > > I'm busily scanning the docs now but so far have had no luck ... > > > > Thanks in advance ... > > > > Steve Brett > > SID > > There is neither assistance by standard SQL nor by SAP > DB-specific-syntax > available. > You will need to check one table after the other by your application. > > Elke > SAP Labs Berlin > _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
