Add a "-" in the middle of a string

[cdulong]

I need a formula that will add a "-" after the fourth character of a string, then add the remainder of the string after the "-".

Thanks,

 

[jdemmi]

mid({table.field},1,4) & '-' & mid({table.field},4)

-- Jason
"It's Just Ones and Zeros

 

[jdemmi]

OOPS...

mid({table.field},1,4) & '-' & mid({table.field},5)

-- Jason
"It's Just Ones and Zeros

 

[cdulong]

Thanks!!

Works like a charm.

CD