If field one begins with a capital letter and field

two begins with a lowercase letter, (the sentence was split into two) how do I search to find all field two's that begin with lowercase and join them back up with field one and leave all field two's that begin in uppercase alone?.

This is the calc that you have to apply to a [color:red]copy of your DB.

1)Insert the cursor into the field1

2)Records --> Replace Field Contents... --> Replace with calculated result: --> Specify

Case (

Length ( Filter ( Left ( field2 ; 1 ) ; "ABCDEFGHJKILMNOPQRSTUVWXYZ" ) ) ; field2 ;

field1 & " " & field2

)

Remember to do this to a [color:red]COPY of your DB

Thanks for the speedy reply.

I'll let you know how I get on.

Cheers

Mark

A little typo:

Case (

Length ( Filter ( Left ( field2 ; 1 ) ; "ABCDEFGHJKILMNOPQRSTUVWXYZ" ) ) ; [color:red]field1 ;

field1 & " " & field2

)