shell scripts question

Hi
I am trying to do the following
use a shell script to draw from various online table to the table on my server. it draws from one online table which has a set of columns one of which is in the form say 2006ab i want to use this as input to copy into another column an http link that has xxxxx/2006/06ab.html. any advice is much appreciated
wbg