Number of characters in a field

  • Thread starter Thread starter Scott
  • Start date Start date
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
 
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
 
Van said:
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.
Click to expand...

Many people don't have problems with memo fields corrupting some (like
me) have and it is not pretty.

I should remember, but I don't recall what happens if you just convert
the field type.
2. Use a Query like:

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


Scott said:
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
Click to expand...
Click to expand...
 
Back
Top