Select [GLAccGLCaption] with invalid TableName

Select * from [GLAccGLCaption] where Not [TableName] in ('(None)', 'ClientType', 'SupplierType')

Select [DBId], [GLAccountId], [TableId], [GLCaptionPlanId], [GLCaptionId], [DGLCaptionId], [CGLCaptionId] from [GLAccGLCaption] Group by [DBId], [GLAccountId], [TableId], [GLCaptionPlanId], [GLCaptionId], [DGLCaptionId], [CGLCaptionId] having count(*) > 1 order by [DBId], [GLAccountId]

Update [GLAccGLCaption] Set [TableName] = '(None)' where Not [TableName] in ('(None)')