sql how to cast a select query

Question

Is it possible to apply the cast function to a select statement  If yes  how  I have a query that returns a number which I have to use a string to get other info s from another table

User · Answer

And when you use a case    CASE WHEN TB1 COD IS NULL THEN     TB1 COD      -      TB1 NAME ELSE     TB1 COD      -      TB1 NAME      -      TB NM TABELAFRETE END AS NR FRETE

User · Answer

Yes you can do     Syntax for CAST     CAST   expression AS data type     length         For example   CAST MyColumn AS Varchar 10     CAST in SELECT Statement   Select CAST MyColumn AS Varchar 10   AS MyColumn FROM MyTable   See for more information CAST and CONVERT  Transact-SQL

User · Answer

You just CAST   this way  SELECT cast yourNumber as varchar 10   FROM yourTable   Then if you want to JOIN based on it  you can use   SELECT   FROM yourTable t1 INNER JOIN yourOtherTable t2     on cast t1 yourNumber as varchar 10     t2 yourString

User · Answer

I interpreted the question as using cast on a subquery   Yes  you can do that   select cast   lt subquery gt   as  lt newtype gt     If you do so  then you need to be sure that the  returns one row and one value   And  since it returns one value  you could put the cast in the subquery instead   select  select cast  lt val gt  as  lt newtype gt

User · Answer

If you re using SQL  which you didn t say    select cast column as varchar 200   from table    You can use it in any statement  for example   select value where othervalue in  select cast column as varchar 200   from table  from othertable   If you want to do a join query  the answer is here already in another post

[sql] sql how to cast a select query

Examples related to sql

Examples related to sql-server-2008