I have three salesmen out on the road demonstrating our latest product on their laptops - an asp.net (1.1) application installed locally on their machine that talks to a SQL Server database instance also installed on their machine.(MSDE 2000) I would like to send upgrades to them and make the process as simple as possible for them (I can't sell - they can't program!). Carrying out the upgrade via one click would be ideal. The updates could be anything from appending a single stored procedure to creating new tables etc. Can anyone suggest a good way of doing this? Many thanks in advance.:) MJ

Hi assuming the character is always a space you could use the split() function: ---------------------------------------------------------- Dim _str As String = "07915 25D3" dim _s as string = str.Split(" ")(1).ToString ---------------------------------------------------------- In this instance _s will give you the value 25D3. The argument passed into the split function is a character or number of characters are used to break down the string into an array. The value of _s is evaluated to the 2nd element of the array (25D3) Hope this helps:) MJ

I think you're talking about the "comprehension gap" that often exists between management/commercial/customers and the development team. I haven't worked anywhere that doesn't have this situation. As a developer I used to become frustrated by the constant rework generated from a meeting with the commercial group but now I realise that its important for two reasons. 1. The more reworks requested by commercial the closer we, as a development team (yes that includes management/commercial/customers and the developers) get to a product that they are happy with. 2. If they (commercial) are happy with the product, the greater chance they can sell it to customers and pay mthe developer their salaries! It may sounds like I'm high as kite, secretly a sales manager or making this up as I go along but using this theory gets me through the day. Expect change... think Agile.... Cynic is what a pessimist calls a realist!!!