The following article does a fantastic job about listing string limitations on MOSS:

 

SharePoint 2007 Maximum Limitations