SQLTeam.com | Weblogs | Forums

Converting Access Code to TSQL

Hello experts,
I've been tasked with converting some Access querys to SQl.
These are 2 examples I need to ask about.

  1. Like "YFSY*" in TSQL is Like 'YFSY%' correct?

  2. where Date1 > NOW() - 120 converts to TSQL as where Date1 > getDate() - 120 is that correct?
    dteShipDate is smalldatetime and contains 2022-06-07 00:00:00 for example time is blank


You got it

You can also use dateadd function for the latter