[thelist] substring and a join?

Joshua OIson joshua at alphashop.net
Sun Mar 4 11:34:43 CST 2001


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





More information about the thelist mailing list