Daniel Kessler wrote: > > ( > DECLARE @find varchar(30) > SELECT p.publication_name, p.publication_id, > o.dept,o.link AS author_link, > NVL(o.lname, a.a_lname) AS lastname, > NVL(o.mname, a.a_mname) || '.' AS middlename, > NVL(o.fname, a.a_fname) AS firstname, > a.publicationa_id > FROM publications p > INNER JOIN publications_authors a > ON p.publication_id = a.publication_id > ) > > So, the question is, how do I declare a variable and set it to > blank?
Why do you want to declare a variable? You are not even using it in your statement. What is the problem for which you think a variable declaration is the solution? Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277314 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
