VarChar field that is 1000 characters in DB

[Scrabble]

Have some reports. they all work but I've never ven tried our last report because it uses a field that is 1000 characters long(the data in it may not be that long). Before Crystal came along we used delphi to strip the text field of the unneeded parts. At the end we would come up with a number, either a percent or some sorta principale balance number.

My question is can I take this 1000 character field and put it into a formula to strip away certain parts(i.e. +++ ---|||) and compare numbers in this field.

I guess i'm really looking for if crystal can strip or cutoff chars and handle a 1000 character field.

 

[jazerr]

Crystal only allows Formula evaluations of varchar(255) or less. Any bigger than that and it sees the field as a blob, and cannot evaluate it.

Your best bet would be to manipulate it in a stored procedure BEFORE it reaches the report.