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