Syntax Problem

[tmumaw]

Hello everyone,

I am having an issue with my syntax and was wondering if someone could help me.  I only want the first 13 positions.  What am I doing wrong?  Thanks

if(len(Address2_Telephone1) >= 12,

         (Mid(Replace(Replace(Replace(Address2_Telephone1,' ',''),Chr(10),' '),Chr(13),' '),1,13)))  as New_Address2_Telephone1,

[swuehl]

And this is exactely what I get:

New_Address2_Telephone1
(330)876-5412

[settu_periasamy]

I calculated including  ( ) -.

So, i think it would be 13..but not sure..

[sunny_talwar]

Sorry I just didn't notice the ()-. You are right.