>>Consider the following SELECT statement:
>>

>>SELECT Id,
>>       0 AS MyNumber
>>FROM   MyTable
>>

>>
>>How can I make sure the MyNumber field is a specific type, e.g., tinyint or int?
>>
>>
>>Thanks,
>>Einar
>
>

>SELECT Id,
>       CAST(0 as int) AS MyNumber
>FROM   MyTable
>

>
>or
>

>SELECT Id,
>       CAST(0 as tinyint) AS MyNumber
>FROM   MyTable
>

Thanks Borislav. Solution stars have been issued. (I feel bad I didn't think of the cast function myself)

Einar