Other workaround (Re: Problem with LEFT JOIN, WHERE and LIKE (Errorin SAP DB?))

[Benjamin Lukner]

Benjamin Lukner wrote:

Are you able to say when it will be fixed?
(I just migrated to Win32 SAP DB and ODBC 7.4.3.27)
And the problem still persists.

Other workaround:
(Too easy, so I had the idea only now ;-) )
SELECT MyStore.PalletID, MyStore.ArtNo, MyArt.Description
 FROM MyStore
 LEFT JOIN MyArt
 ON MyStore.ArtNo = MyArt.ArtNo
 WHERE MyArt.Description LIKE 'Huge%'
 AND MyArt.Description IS NOT NULL
The last line filters the data given back by error.

Benjamin Lukner
trinomix GmbH
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general