Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: jmr23
  • Order by date
  1. jmr23

    Newbie Ist time query

    You are dealing with typing in both instances. What is the datatype of column "deal" If it is a bit then you must use 1/0 not "true" or "false" If it is an int, same story. If it is a varchar column then 'true' should work fine. As for the date comparison, here are some ideas: DECLARE @date...

Part and Inventory Search

Back
Top