how do i define the datatype of a column within a SELECT INTO query?
so for example
'' as subject
After this query is ran i need to manually update the datatype of this table to real from varchar(1)
can i update the dataype within the SELECT INTO query or can i do this outside
Sam, which column do you mean? In general use the CAST() function to set the datatype from a select statement.
I don't see any of these that look like they have a datatype of real. Also, casting a real to a varchar(1) looks like something that might be likely to cause problems -- it doesn't look like there is anything in your select statement that should be
cast as varchar(1).
Case(age as varchar(1)) is likely to truncate as is everything else; what exactly do you mean?