cast(Rooms as varchar(2))
例如:
SELECT cast(Rooms as varchar(2))+'室'+cast(Halls as varchar(2))+'厅'+cast(Toilets as varchar(2))+'卫 '+StylePro
as SBStyle
FROM F_USR_SBSearchResult
cast(Rooms as varchar(2))
例如:
SELECT cast(Rooms as varchar(2))+'室'+cast(Halls as varchar(2))+'厅'+cast(Toilets as varchar(2))+'卫 '+StylePro
as SBStyle
FROM F_USR_SBSearchResult
转载于:https://www.cnblogs.com/wangpei/archive/2008/10/18/1314050.html