Excel関数

=Right(b2,6)

=left(b2,6)

=SUBSTITUTE( b2, "ｶﾌﾞｼｷｶﾞｲｼｬ", "" )　　//ｶﾌﾞｼｷｶﾞｲｼｬ を除外

ALTER TABLE m_tabl ALTER COLUMN m_name TYPE VARCHAR(1024);