You won't be able to do this exactly as you think. You can't type something and have it create something else.
What you can do is give yourself a shortcut by only typing the short versions by creating two tables and then outputting from the two tables if you want your users to see them in long version.
something like:
Code:
create table mylookuptable(
shortversion char(1),
longversion varchar(15));
create table movies(
id int,
movietitle varchar(50),
movietype char(1),
foo char(10),
bar char(10));
in the mylookuptable insert data once for each type of movie genre.
in the movies table itself you would then only need the short version.
then when you want the output you can do something like:
Code:
select movietitle, longversion, foo, bar
from movies, mylookuptable
where movietype=shortversion
dBforums
>
HELP!! Concatenating List
10-21-04, 11:59
Linear Mode
