Limiting characters returned in query results

[rockyroad]

Hello,

Does anyone know of a way (function etc) to limit the number of characters returned in a query? I want to use say the first 50 characters from a Description column on SQL query, to use in a basic search results template. I know that with Verity searches, this is something that can be set... any ideas on how to accomplish this with a simple SQL query?

Thanks Much,

RR

 

[Xenobia]

It is possible to use some VBA functions in queries. so you can do it by setting the content of your query field as follows.

shortDescription: left$([tablename].[description],50)