Number of characters in a field

S

Scott

I have a Memo field which I would like to convert to a
text field, in order to avoid database corruption, now is
there any way how I can get the number of characters I
have in each record of the Memo field using a query. ?
so that I will be able to narrow down the criteria to >
250, and I will update those records to include only 250
characters. ?


Thanks


Scott
 
V

Van T. Dinh

1. I don't seem to have database corruptions due to Memo Field so I am not
sure whether converting to Text Field will help. Certainly, it is more
efficient to retrieve Text Field.

2. Use a Query like:

SELECT *
FROM [YourTable]
WHERE Len([MemoField] > 250
 
Top