PLEASE HELP - wildcard characters in SQL

Results 1 to 2 of 2

Thread: PLEASE HELP - wildcard characters in SQL

  1. #1
    Join Date
    Dec 1969
    Posts
    38

    Default PLEASE HELP - wildcard characters in SQL

    Any help from you guys is greatly appreciated... I have a question about using wildcard characters in SQL Statements. I know that for alphanumeric data types, it is done by adding a "%" (e.g. .... WHERE [FieldName] LIKE &#039ca%&#039). My question is, what about Date/Time data type? Please help!!<BR><BR>Thanks very much,<BR>Vince

  2. #2
    Chad Franklin Guest

    Default RE: PLEASE HELP - wildcard characters in SQL

    Simple answer<BR><BR>WHERE ((dbo_activity.act_dt)&#060;=#" & Request.QueryString("FinishDate") & "# And (dbo_activity.act_dt)>=#" & Request.QueryString("StartDate") & "#)<BR><BR>There are better way of doing this.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •