Expand|Select|Wrap|Line Numbers
- if request("txtSearch2") = "" then
- 'select case sens
- if request("Sense")= "on" then
- sqlPRJ = "SELECT TCKT_ID,TCKT_OPN_DATE,TCKT_DESC FROM TCKTs WHERE TCKT_DESC like '%'+'"&request("txtSearch1")&"'+'%'COLLATE SQL_Latin1_General_CP1_CS_AS"
- else
- sqlPRJ = "SELECT TCKT_ID,TCKT_OPN_DATE,TCKT_DESC FROM TCKTs WHERE TCKT_DESC like '%'+'"&request("txtSearch1")&"'+'%'"
- end if
- end if