>Hello everyone,
>
>I am trying to write my first check constraint in SQL server. I want to make sure that the column in question is not empty. In Fox, I would say something like :-
>
>

>And Not Empty(tablename.columnname)
>

>
>What is the best way to express this in SQL server using T-SQL ?
>
>Thank you!
>
>Angie.

On VFP EMPTY() ignore spaces chr(9|10|13).

For a zero lengh string ( ignoring spaces ):

AND LEN(tablename.columnname)>0