Dear Drew

Further to the great solution you gave me I have a problem with some results that I just can't figure out. I am trying to return a money...

Dear Thom

Thank you very much for responding - your solution works very well and gives me the results that I need. I have marked the solution below as the solution...

Dear Drew

Thank you so much for this - it is very cool and succinct and does what I needed perfectly. There is no way that I could have worked...

Hi Lowell

Thank you so much for this. I had made some changes that "worked" but still had issues with my HTML. Your solution works perfectly and produces the expected HTML.

Kind...

Hi Lowell

Thank you very much for your reply. I understand there is lots wrong with my code but I don't know how to fiddle with the formatting to get the...

Hi thank you so much for this, it was a huge help. Part of my problem was the null values which Ii thought I had prevented by using <xsl:if test...

Hi thanks so much for replying and helping me however when I make the change you suggest the result I get is :

Result -

Item $

1.5 69

0.5 23

Subtotal...

Thank you very much for responding again Wayne. That is obviously such a simple solution!

Kind regards, Sally

Wayne

Thanks so much for your response which has worked to give me the correct prefixes in my new terms.

Can you please tell me how to change the prefix matching...

Dear ColdCoffee

Thank you very much for going to so much effort to help me solve my substring problem. Unfortunately I am working in SQL2000 so I think the WITH statement...

Dear Wayne

Thank very much for your advice which I have tried to use to respond to the above post. I hope that I have done this correctly as I find...

Dear ColdCoffee

Thank you very much for responding to my request for help. I have tried to follow Wayne's advice (below) re posting my data so I hope I have done...

Hi Jeff

Thanks for this suggestion. I will make a view with this conversion and a couple of other similar ones so that I don't have to rack my brains again...

Hi Jeff

Thanks very much for your help. I thought it was something quite simple, but couldn't get my head around it. Have used the cast convert statement and get the...