[prev in list] [next in list] [prev in thread] [next in thread] 

List:       sapdb-general
Subject:    RE: BLOB
From:       "Zabach, Elke" <elke.zabach () sap ! com>
Date:       2006-08-08 8:30:49
Message-ID: 235EE6AC8AE9264CBF763FC6749E270104805B74 () dewdfe22 ! wdf ! sap ! corp
[Download RAW message or body]

 Guhr, Hagen wrote

> Hi,
>  
> im searching for a way to find out if a database-blob exsist. 
> There are 
> column entries like this one in my table: Name: "L_DATA_4"           
> Datatype: Long BYTE.
>  
> Now I try to find out if there is some data in this column without 
> reading the whole blob. Is there a way to create a 
> SQL-Statement with a 
> WHERE-Clause like: where L_DATA_4 > 0 ?
>  

where L_DATA_4 IS NOT NULL
should help

Elke


> 
> Thanks
> 

-- 
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/maxdb?unsub=sapdb-general@progressive-comp.com


[prev in list] [next in list] [prev in thread] [next in thread]