General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Ok, I see what you mean. I just checked the MAP and Robert beat me to my answer. That's the best I can think of.
Michelle
>You're right, the field length is 4, but the actual length of the value in that field can be 10 (or 11). I need to know the length of the "longest" value in the table in this integer field. With character fields I can use LEN() and select MAX(LEN(ALLTR(FieldName))). But with numeric fields I have a problem. Maybe you have another solution for this?
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only