Hi
I'm useing a Database Lookup and some Value Extractor Functiods to retrieve 
some data in the mapper. The result from the value extractors are mapped to 
elements in the destination schema. If a value is null or emtystring in the 
database I don't want the e
lement to be created. I connect for example a Not Equal Functoid to the out 
put of the extractor and to the element in the destination schema. This work
s fine when i checking a value from the source shema, but not a value from a
 databse value extractor. I
have tried several ways of doing this for example checking the string length
, or Logical String Functiod. Nothing seams to work.

Does anyone know why this is happening?  Your help is much
appreciated.

[ Post a follow-up to this message ]

What  is the value of the second input parameter in the "Not Equal"
functoid?  Try with empty value.  Also, you'll need to use a Value Mapping
functoid in case the Value Extractor is returning a value.

Regards,
Tan Nguyen
Microsoft BizTalk Server

This posting is provided "AS IS" with no warranties, and confers no rights.

--------------------[vbcol=seagreen] 
not work[vbcol=seagreen] 
Sand@discussions.microsoft.com>[vbcol=seagreen] 
work[vbcol=seagreen] 
retrieve some data in the mapper. The result from the value extractors are
mapped to elements in the destination schema. If a value is null or
emtystring in the database I don't want the element to be created. I
connect for example a Not Equal Functoid to the out put of the extractor
and to the element in the destination schema. This works fine when i
checking a value from the source shema, but not a value from a databse
value extractor. I have tried several ways of doing this for example
checking the string length, or Logical String Functiod. Nothing seams to
work.[vbcol=seagreen] 

[ Post a follow-up to this message ]