conver float to string in the query

[Kendel]

Hi All,

I know I can break a column's value after I get the result set but can I break it in the SQL statement. something like:

Select Left(column2,4) as first4, Right(column2,4) as last4
from ...blab ..blab

The data type of column2 is a float so I need to convert it to a string first. Can someone please help me with syntax? Thanks.

 

[Kendel]

If you've ever ran into this problem, it's:

SELECT LEFT(CHAR(COLUMN NAME),5) ....