怎么从Memo字段（Varchar，length＝60）取出前十个字符？？？？谢谢。

[jilongge]

我的数据库程序如下：
<%
set conn=server.createobject("adodb.connection")
conn.open "Provider=SQLOLEDB;data source=whg;uid=sa;pwd=1;database=Cab_Mis"

Set rsCustomers = Server.CreateObject("ADODB.Recordset")

strSQL = "SELECT * FROM position "
rsCustomers.Open strSQL, conn

Set Pos_Name = rsCustomers("Position_Name")
Set Sala_Max = rsCustomers("SalaryMax")
Set Pos_ID = rsCustomers("Position_ID")
Set Sala_Mid = rsCustomers("SalaryMid")
Set Sala_Min = rsCustomers("SalaryMin")
Set Memo = rsCustomers("Memo")

%>

[iStringTheory]

left(rsCustomers("Memo"),10)

[BrightEye]

你的意思是什么？取字段的值撒？
<%trimMemo=Left(Memo,10)%>

[jilongge]

能否将详细点，谢谢！！！怎么使用？请直接在程序里更改

[jilongge]

请大家帮忙阿！！！！！！！！

[chi0591]

Memo = left(rsCustomers("Memo"),10)