请问这个SQL语句怎么写？

[ward]

SQL="select * from " & NewsTable & " where NewsSort=" & NewsSort & " Order by newsdate desc"
其中NewsTable和NewsSort是当作参数传过来的。数据库中NewsSort是文本，所以上述语句总是出错，请问应该怎么改动才能实现？

[ttt2]

SQL="select * from " & NewsTable & " where NewsSort='" & NewsSort & "' Order by newsdate desc"

[2599]

SQL="select * from " & NewsTable & " where NewsSort='" & NewsSort & "' Order by newsdate desc"

[maxid]

SQL="select * from " & NewsTable & " where NewsSort='" & NewsSort & "' Order by newsdate desc"
你可以把SQL显示出来看看嘛。Response.Write SQL 看看有没有错