update channel
set
xmltvid = b.xmltvid
from channel a, channel b
where
a.name like b.channum and
left(a.channum,1) between 0 and 9