Select Cast(height as varchar(20)) + ' X ' + Cast(width as varchar(20)) + ' ' + unit from [Tablename]
Select convert(varchar(20) , height ) + ' x ' + convert(varchar(20) ,width ) + ' ' + unit from UrTable
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)