In my links2. in site_html_templates.pl I had this sub to convert state abbreviations to full state names to be returned back to my link, category, detailed and other templates.

sub state_name {
my $state = shift;
my %abr = (
AL => "Alabama",
AK => "Alaska",
AZ => "Arizona",
etc.,
WI => "Wisconsin",
WY => "Wyoming",
);
return $abr{$state};
}

Then use in &load_template routines, use
state_full => state_name ($rec{'State'}),

How can I do this in links sql?
Thank you!