Answer form one of my students

来源: 2012-11-14 15:54:31 [博客] [旧帖] [给我悄悄话] 本文已被阅读:

declare @Astring varchar(200)

set @AString = 'Where am I?'

select substring(@AString, 10, 1)+' '+substring(@AString, 7, 3)+substring(
@AString, 2, 4)