select *
into OUT_TABLE
from IN_TABLE
where 0 = 1;

SELECT IsNull(field, 0) FROM A;
SELECT SUBSTRING(FirstName, 1, 1) FROM A;
SELECT Len(field, 0) FROM A;