declare SQL text; NSQL text; SQL := ''10/3/2009'';
NSQL := quote_literal(SQL); The result is '10/3/2009 with no closing quote. Jim James M Doherty Principal <file://C:\Documents and Settings\jmd\Application Data\Microsoft\Signatures\odoherty_crest.jpg> JMD CONSULTING 411 Thunderbay Dr Georgetown, TX 78626 A reputation is something others give you HONOR is something you give yourself! ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings