I am trying to remove the trailing whitespace while querying it from the input XML.i Can't use the normalize-space method since it will remove the all the whitespaces (i.e whitespaces between characters)

Please Help me in this!!!

normalize-whitespace does not remove all whitespace: it removes leading and trailing whitespace, and replaces internal sequences of whitespace characters with a single space.

In 2.0 you can trim trailing whitespace using

replace($in, "\s*$", "")

(not tested)

In 1.0, I think you'll need to write a recursive template that tests the last character to see if it's a space (substring($in, string-length($in), 1)) and if so, strips it off and recurses.

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