I am trying to create an If Else Update Script. This is what I have put together so far:
IF (SELECT [FileType1] FROM Document WHERE ([FileType1] like 'E-mail' or [FileType1] like 'outlook'))
update Document
set [FilePath]=''
ELSE ((SELECT [FileType1] FROM Document WHERE ([FileType1] not like 'E-mail' or [FileType1] not like 'outlook'))
update Document
set [Path]=''
What I am I doing wrong?