>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,

Look at the DATALENTH() function in SQL-DOL. Also if the field accepts null values you'd use IS NULL.