SELECT FLM_TITRE, FML_ANNEE, DRURLCOMPLETE(FLM_FILM) AS FLM_MPEG
FROM   T_FILM_FLM
WHERE  FLM_ID = 178

/*
FLM_TITRE         FML_ANNEE    FLM_MPEG
----------------- ------------ ---------------------------------------
West Side Story   1960         file://srvmed/films/WesSideStory.mpeg
*/
