Your question is far from clear. Perhaps you're looking for the
EXISTS
clause?
EXISTS (Transact-SQL) - SQL Server | Microsoft Docs[
^]
SELECT
SomeColumns
FROM
YourTable
WHERE
Exists
(
SELECT 1
FROM YourTable
WHERE YourDateColumn = CONVERT (date, SYSDATETIME())
)
;
Or, if the column contains the date and time:
...
WHERE YourDateTimeColumn >= CONVERT (date, SYSDATETIME())
And YourDateTimeColumn < DateAdd(day, 1, CONVERT (date, SYSDATETIME()))
...