ALTER TABLE VS4TBank ADD
	TBnkShortName nvarchar(30) NULL
GO
UPdate VS4TBank Set TBnkshortName=left(rtrim(ltrim(replace(replace(replace(TBnkName,'ธนาคาร',''),'จำกัด',''),'(มหาชน)',''))),30) WHERE TBnkshortName='' or TBnkshortName is null
GO