title: sql how to cast a select query
body: <p>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.</p>