请求前辈帮忙看一下！

onesex

Dim mRs
    Set mRs=Conn.ExeCute("Select Title,Popedom,RoleTitle,Lock,NickName,ClassPopedom,ClassId From View_AdminInfo Where UCase(Title)='" & UCase(mTitle) & "' And Pwd='" & mPwd &"'")

这句话原来是用在access2000的数据库的，现在我改用SQL2000，所以会出现“[Microsoft][ODBC SQL Server Driver][SQL Server]'UCase' is not a recognized function name. "错误。

请问该怎样改才行呢？请教

HG

以下是引用onesex在2004-2-22 21:43:35的发言：
Dim mRs
     Set mRs=Conn.ExeCute("Select Title,Popedom,RoleTitle,Lock,NickName,ClassPopedom,ClassId From View_AdminInfo Where UCase(Title)='" & UCase(mTitle) & "' And Pwd='" & mPwd &"'")

这句话原来是用在access2000的数据库的，现在我改用SQL2000，所以会出现“[Microsoft][ODBC SQL Server Driver][SQL Server]'UCase' is not a recognized function name. "错误。

请问该怎样改才行呢？请教

因为Ucase不是Tsql函数所到!(若不经过特列设置SqlServer对大小写并不敏感)!
strsql="Select Title,Popedom,RoleTitle,Lock,NickName,ClassPopedom,ClassId From View_AdminInfo Where upper(Title)='" & UCase(mTitle) & "' And Pwd='" & mPwd &"'"
set rs =conn.execute(strsql)

onesex

非常感激！