Anyone familiar with SQL Server 08 and Check Constraints?

[Astro]

I'm trying to place a check constraint on a FullName column that will combine information from two other columns (FirstName and last Name) and display them together in that column.


I'm using this expression:

[firstName]+' '+[lastname]

Have I missed something out?

[redVENGEANCE]

Maybe an "&" between field names?

Sent from my Hero using Tapatalk