Report for Brief comments with no begin date

01/11/2024 9:34 am EST

SELECT AccountNumber
FROM AccountMain
WHERE ID in
(
SELECT AccountID
FROM AccountComment
WHERE CommentType = 'B' and CommentBeginDate = '1980-01-01 00:00:00' and Comment != '')
and AccountNumber NOT LIKE '~%-%-%'

Was this article helpful?