I need to know the length of long integer. A field that i am retrieving in 

my select statement is that type with the rest of the fields text type.



I have to use functions to get the long integer like,



left(Mystr, 4) mid( ) etc.





What is the actual length of long integer.  I know it is 4 bytes and 

forgot all this stuff in school. So if anyone knows please respond.





Thanks

try the len() function



-----Original Message-----

From: sharon buggle [mailto:s.buggle@w...]

Sent: Monday, October 08, 2001 7:42 AM

To: Access ASP

Subject: [access_asp] Long integer





I need to know the length of long integer. A field that i am retrieving in 

my select statement is that type with the rest of the fields text type.



I have to use functions to get the long integer like,



left(Mystr, 4) mid( ) etc.





What is the actual length of long integer.  I know it is 4 bytes and 

forgot all this stuff in school. So if anyone knows please respond.





Thanks