I have a field called strFullName (SQL 7) that I wish to populate by combining the fields strFName and strLName separated by a space.
Do I do this with ALTER TABLE ALTER COLUMN??
If so, where do I create this statement and what is the syntax I should use. BOL suggests using this method, but I know so little about the language and physical db structure that I can't figure out where to begin.