Memo field length

[Barkley564]

Is it possible to determine the length of a memo field? I don't need to display the field itself, only determine the number of characters it contains.

I'm using CR10 with a SQL server.

 

[elsenorjose]

One of the CR gurus will probably come up with an answer on doing this with CR but in the meantime, you could find that information through a straight SQL query using query analyzer. This query will retrieve the length of the longest field in the table:

SELECT MAX(LENGTH(FIELD_NAME)) FROM TABLE

 

[dgillz]

What version of Crystal? You should never post a question without this info.

In crystal XI, you can write a simple formula:

Length({YourMemoField})

Note that this will return the length if the DATA in the field, not the length of the field itself.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"If you have a big enough dictionary, just about everything is a word"
--Dave Barry