MS SQL 2000 - Selecting the first X chars in a nvarchar column

[mreyes]

I have a simple db table with the following structure :

ID - int
TEXT - nvarchar
TITLE - nvarchar

The text field will take alot of plain text, but I need to be able to display a brief summary and to do this I want to somehow select the first 100 characters (as an example)

I have looked at the trim function to do this, but cannot seem to get the functionality I need.

Thanks in advance

[mattr]

Try LEFT

[TTT]

SELECT LEFT(text,100) AS text