关于货币查询问题

请问,对于货币型数据查询跟文本和日期是不是不一样?该如何表示?如下代码中,contract_id、debt、charge_time是表charge中的字段，其数据类型分别为文本、货币、日期/时间，但是无法实现根据contract_id查询，是不是sqltext="select * from [charge] where debt='"& trim(request("sc")) &"'order by user_name asc"表示错误，请各位老师指点指点！
If request("st")="contract_id" and request.Form("sc")<>"" Then
        sqltext="select * from [charge] where  contract_id='"&trim(request("sc")) &"' order by id asc"
ElseIf request("st")="debt" and request.Form("sc")<>"" Then
        sqltext="select * from [charge] where debt='"& trim(request("sc")) &"'order by user_name asc"
                ElseIf request("st")="sktime" and request.Form("sc")<>"" Then
        sqltext="select * from [charge] where charge_time=#"& trim(request("sc")) &"# order by user_name asc"