sql查询字段合并

sql查询字段合并效果:
select (cast(COL1 as varchar(40))+'||'+cast(COL2 as varchar(40))) as typesize
 from TableName

posted on 2007-12-13 14:09  jdmei520  阅读(939)  评论(1编辑  收藏  举报

导航