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)