suppose one of my xml node value is...

select c.dept_name, a.transaction_no, a.transaction_date, f.store_name,
          d.item_description, e.unit_description, b.qty, b.sales_price, b.qty*b.sales_price value
from transaction_header_tab a, transaction_detail_tab b, department_tab c,
          item_master_tab d, unit_master_tab e, store_master_tab f
where a.transaction_date >= :p_start_date and
           a.transaction_date <= :p_end_date and
           a.transaction_type = 'I' and
           a.destination_store_code = c.dept_code


i want to put &amp;#10; before every line in xslt 1.0....how can i chive this? is there any way?

String manipulation is much easier in XSLT 2.0. For 1.0, look at the library routines available at www.exslt.org, for example str:tokenize, str:split. Some of these have implementations as XSLT source code templates which you can copy directly into your stylesheet.

Michael Kay
http://www.saxonica.com/
Author, XSLT Programmer's Reference and XPath 2.0 Programmer's Reference