StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 nid from Users "); strSql.Append(" where (userName collate Chinese_PRC_CS_AS=@userName or mobile collate Chinese_PRC_CS_AS=@userName or Email collate Chinese_PRC_CS_AS=@userName) and userPwd=@userPwd");