如何批量将会员卡号中的小写转换为大写？

如何批量将会员卡号中的小写转换为大写？

在查询分析器中执行以下语句进行修改。

use isszmv8

go

declare @ls_tablename varchar(50),@ls_sql varchar(500)

declare test_cur cursor for

SELECT pbc_tnam

        FROM pbcatcol

        WHERE pbc_cnam = ‘card_id’

        ORDER BY pbc_tnam 

        for read only

open test_cur

fetch test_cur into @ls_tablename;

while @@fetch_Status = 0

begin

set @ls_sql=’update’ +’  ‘  +@ls_tablename+’   set card_id=upper(card_id)’

exec( @ls_sql)

fetch test_cur into @ls_tablename;

end

close test_cur

deallocate test_cur