One thing that sometimes works is the convert function. In Sybase ASE, for example, you may not be able to use the substring function on a text type field, however, you can use Convert(varchar(250, fieldname) to accomplish the same thing. -joshua