Can CAST and CONVERT be used in a table creation
<p>I have never tried this sort of SQL query before, so excuse me for asking this question.  Is it possible to use CAST and CONVERT in a table creation?</p>

<pre><code>   create table Owner
(
    Id      int identity(0,1) 
,   Name        nvarchar(200)
,   CountryId   int
,   PolicyNumber    AS (CONVERT(CountryId AS char(3)) + CONVERT(Id AS char(10)) varchar(40)
)
go
</code></pre>