Changing Field Lengths

[twilliamson2]

Hi,

I am using Crystal 10 with an Oracle DB. I have to convert a large amount of data based on certain field formats.

For example, in the Oracle DB, the "Name" field is 60 characters. How can I change the field length to 30 characters?

 

[Madawc]

You can get the first 30 characters using

Left(your.field}, 30)

This will lose the other 30. You can use Right(your.field}, 30) to get that. There is also Length(your.field}) to check how much of a field is really used.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10