Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Kathi Kellenberger Sql Function in where clause RE: Sql Function in where clause

  • February 11, 2016 at 10:52 am

    #1858107

    Select Jcdtl.mdoc_no,Jcdtl.doc,no,jcdtl.doc_dt,jcdtl.del_dt from jcdtl

    Where MONTH(jcdtl.doc_dt)=3 AND YEAR(jcdtl.doc_dt)=2014

    In this table have approx 10 lacks rcords