The Mess Hall

Posted: **Fri Mar 11, 2011 7:47 pm**

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? $:-\$

Posted: **Fri Mar 11, 2011 10:31 pm**

Maybe an "&" between field names?

Sent from my Hero using Tapatalk

The Mess Hall

Anyone familiar with SQL Server 08 and Check Constraints?

Anyone familiar with SQL Server 08 and Check Constraints?

Re: Anyone familiar with SQL Server 08 and Check Constraints