Doubt in trim function

[swathi Singamareddygari]

Hi all,

Can any one please tell me the deifference between below two trim syntaxes

1.Trim(DSLink2.Date,'0','%R%')
2.Trim(DSLink2.Date,'0','R')

I creaeted the sample job to check these two syntaxes but i didnt get the difference in using with and without % syntax.

Thanks

Swathi

[ray.wurlod]

The first syntax is, essentially, invalid and so will default the third argument (to "B" or "T" - I can't remember which).

[swathi Singamareddygari]

The first syntax is, essentially, invalid and so will default the third argument (to "B" or "T" - I can't remember which). ...

Hi ray ,

first statement is not invalid its giving the same result as of the second one.but i am not getting the differencebetween those two.

Thanks

[ray.wurlod]

Prove to me that it's valid, with a reference to a manual.

That it works is not proof - as I noted, invalid arguments can be ignored and take default values.