好久没研究ASP了，难得今天研究了个就留着以后备用吧。

获取英文名字的首字母。比如英文名“Candy Lee”，获取后显示"CL"

name=split("Candy Lee"," ")

name1=name(0)

name2=name(1)

FirstWord = left(name1,1)

SecondWord = left(name2,1)

Response.Write FirstWord&SecondWord

输出结果为：CL

连上数据库时，把“Candy Lee”替换成字段名即可。

<%

strsql="select * from 表 order by ID desc"

set rs = Server.CreateObject("ADODB.Recordset")

rs.Open strsql, conn, 1, 1

while not rs.eof

name=split(rs("name")," ")

name1=name(0)

name2=name(1)

FirstWord = left(name1,1)

SecondWord = left(name2,1)

Response.Write FirstWord&SecondWord&"<BR>"

rs.movenext

wend

rs.close

set rs=nothing

%>