LIke statement help

  • Thread starter Thread starter one1george
  • Start date Start date
O

one1george

here is an example of how i am trying to use the like
statememt.....
this works for text but not date/time.
strEvTraining = " Like '*' "

I have tryed to change to code too " like #*# " but it
won't work.

thanks
 
Your statement implies you want all dates so why not just leave the criteria
blank.
 
no i am trying to run a query from a form
using the like statement to set the criteria in the query.
when i use like '*' this won't work because the ' part of
the code only works for text not date/time.
# is used for date/time and i would to incorperate this
into the code but i can't get the like statement to accept
is in the criteria of the query i am running.

thanks
 
Same question - like '*' if it did work would return all dates so why not
just leave the criteria blank?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

like statement help 1
forms() err - Can't find the form "frmDspEvents" 4
Size Jump 2
Date in SQL Insert statement 2
App_Code class call funcrion in aspx.cs file? 11
Like statement for date/time criteria 5
Modify sql statement 2
Coding wildcards in search criteia 2

Back
Top