Question on CDATA usage

[ooper]

Just wondering if it matters how much of the query you include within the CDATA element?

Is one of these preferable over the other? Why?

SELECT *
FROM my_table
WHERE my_column = #value# AND
my_date <= GETDATE()
]]>


SELECT *
FROM my_table
WHERE my_column = #value# AND
my_date <= GETDATE()
]]>

TIA,
Brian Barnett


Broadband interface (RIA) + mail box saftey = http://iBatis_for_Java_Users_List.roomity.com
*Your* clubs, no sign up to read, ad supported; try broadband internet.