Hello experts I have a database called BadgeDB which has a table dbo.ContractorBadges with a Column of
The Name field is currently a free form text field. The purpose of this field is to accept both the first and last name of a Contractor. If only one name is entered instead of first and last our import will fail as it will leave the “last name” within our database blank resulting in the data not coming across our interface.
I would like to put a constraint on this field to ensure that both first and last name are entered – example at least one blank space – is input therefore creating two words or names in the field. Further enhancement is to create another constraint to disallow and symbols from being entered in the field. Symbols such as ! @ # $ % ^ & * ( ) - ? < > / should not be accepted
How would I go about writing both or a single constraints for doing this?
Thank you so much for your time.