I'm a bit of an SQL novice.
I've been trying to create an auto generated column called
TAG from 5 other columns, some of which can retain NULL marks.
The syntax used to create the auto generated column is:
[Tag] AS ([Tag Type]+[Parent Tag Type]+[Tag Area No]+[Tag seq No]+[Tag Suffix])
This autogenerates OK if none of the five columns retains a NULL, but if I try to create a row with any one of the columns containing a NULL, the auto generate does not work, and leaves the
TAG column blank, even though it creates the row OK with the all the individual column data.
Is there a way I can get the auto generate to work with NULLs?