Home Forums SQL Server 2008 T-SQL (SS2K8) Finding a table with date appended to it and check for the range of that date RE: Finding a table with date appended to it and check for the range of that date

  • September 5, 2012 at 1:41 am

    #1533655

    Hi Prasad,

    In order to search for the table we can use sys.tables as below, also inorder to convert date to month you can use datepart function.

    Hope this helps.

    select * from sys.tables where name like '%YYYYMM%'

    Thanks.