>Hi,
>
>I tried to add the following constraint but getting error "Incorrect syntax near 'LEN'".
>
>Here is the syntax of my constraint:
>

>alter table [dbo].[Projects] with check add constraint [CK_Projects_ProjectAccount] 
>check LEN(ProjectAccount) > 0
>

>
>What is wrong with this constraint?

alter table [dbo].[Projects] with check add constraint [CK_Projects_ProjectAccount] 
check ( LEN(ProjectAccount) > 0 )

Cetin