if then else issue

Minhajuddin · Post by **Minhajuddin** » Fri Jun 15, 2007 11:32 pm

ray.wurlod wrote:Trim() can never generate "". ...

Hi Ray,

I have used this a lot in Server Jobs. And Trim(col) gives me the same as Convert(" ","",col).

Does it behave differently in Parallel jobs?

Let me try and get back to you.

And thanks for cautioning us on this.

ray.wurlod · Post by **ray.wurlod** » Fri Jun 15, 2007 11:59 pm

Try it with this value, and post your response.

Code: Select all

"   FREDDIE               MERCURY     "

It is NOT the same result as Convert().

chulett · Post by **chulett** » Sat Jun 16, 2007 12:49 pm

Ray, you may not be an FBG - but you make the rock'n world go round.

samsuf2002 · Post by **samsuf2002** » Mon Jun 18, 2007 7:04 am

I tried using convert funtion to make spaces as empty but now it is giving me as 0 in col B , i found that RCP in enabled is that the issue? not sure