Hi Jeff,

Thanks for yout interest. It has worked out really well.

I put in a formula to calculate the difference in distance between my search centre point and the X\Y...

OK, thanks Wayne 🙂

Charlotte.

Hi Paul, Thanks for the info. Unfortunatly most of the people who use our software areon 2005 and it will probably be several years before they all go to 2008...

Jeff, I can't thank you enough for what you have given me - it's exactly what I needed - you are a star and your efforts (and those of...

John, I've tried your code and it works perfectly. I added a comma to the end of your sample data string to simulate how my data is then I changed...

Wayne, I've tried running your code but it doesn't seem to give the correct splits in values - It may be me doing something wrong though.

Guys, thanks for your replies - I will have a look at these today.

Jeff regarding the X and missing Y, you are correct - it is a lapse in my...

John, thanks for your reply - that article was most useful.

I have now set up the following test...

--===== Create and populate the Tally table on the fly

SELECT TOP 10000

IDENTITY(INT,1,1)...

Perfect Thanks 😀

Thanks for the response, its along the same lines as I had reached already, however it doesn't handle symbols and numbers. Any suggestions?

CCB

John, adding the identity column worked a treat - seems so obvious now

Thanks.

Thanks Farrell.

An error with the count I think - it should be

WHERE LEN( ws.Word) >= LEN( ws2.Word) not

WHERE LEN( ws.Word) <= LEN( ws2.Word)

Please...

Thanks Ian - that would be helpful

Hi,

Even though this is more complex, I think your last scenario is probably the way to go. I do something similar on the corresponding import process where I process the header...

Hi,

Thanks for the response. I was doing that. However, there is a limit with the PowerBuilder function (cerrtainly with PB9) in that it can not put out more than...