Field length search

[pryjda]

Does anyone know how to do a search for fields containing over 500 characters?

Got a big SQL project coming up and need assistance.

Thnak you in advance!

[Zero Tolerence]

The only way I can think to do this right now is to loop through your records, and omit the ones that have over 500 character, then show all omited.

Loop

If[Length(Field) > 499]

Omit record

end if

go to next record(Exit if last)

End Loop

[LaRetta]

You can create a calculation (result is number) with: Length ( theField) > 500

This will produce a 1 which is searchable; in fact, the calc can be stored within a Find Request as:

Field: newCalcField

Value: 1

Use only the Perform Find[] and store the Find Request there (forget Enter Find Mode[] here - it isn't needed). The calc is also indexable as ALL so searching will be fast.

LaRetta :wink2: