Trim(NulltoEmpty(priorSnapshot2.EMPNUM))

srikanth386 · Post by **srikanth386** » Thu Jan 15, 2009 4:27 am

Hi..

Could you help me, how can I use this function in server jobs.

Trim(NulltoEmpty(priorSnapshot2.PRVDR_GRP))

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Thu Jan 15, 2009 6:11 am

By writing a NullToEmpty transformation

chulett · Post by **chulett** » Thu Jan 15, 2009 8:36 am

It already exists. I'm guessing the question really should have been "how do I use this Server function in a Parallel job". Yes?

samsuf2002 · Post by **samsuf2002** » Thu Jan 15, 2009 9:28 am

If IsNull(trim(priorSnapshot2.PRVDR_GRP)) then '' else trim(priorSnapshot2.PRVDR_GRP)

in the column derivation works too.