Ahmad Zayed

Hi

Today at Arab Teem someone ask question about the null and the Space-Key which is not null of course. See this example to know more what I'm talking about.

Have fun.

Bye

Create Table xT

(

FName VarChar ( 30 ) Not Null

)

Go

Insert into xT ( FName ) Values ( Null )

Go

Insert into xT ( FName ) Values ( '' )

Go

Insert into xT ( FName ) Values ( 'Ahamd' )

Go

Alter Table xT With NoCheck

Add Constraint CH_xT_FName Check ( Len ( FName ) > 0 )

Go

Insert into xT ( FName ) Values ( Null )

Go

Insert into xT ( FName ) Values ( '' )

Go

Insert into xT ( FName ) Values ( 'Desigen' )

Go

Select * From xT

Go

Labels: Sql Server