Search results

  1. J

    Using SQL UPDATE with a concantated string containing numbers & letters

    Thanks :) EDIT: Nevermind! I was missing '-1' on the end of each FOR. Ahwell, it might help the next bloke!
  2. J

    Using SQL UPDATE with a concantated string containing numbers & letters

    Yes! That was it! Thankyou very much for that mate, those two button strokes cost me 4-5 hours!
  3. J

    Using SQL UPDATE with a concantated string containing numbers & letters

    I should add, importantly, that it halts on this line:
  4. J

    Using SQL UPDATE with a concantated string containing numbers & letters

    I'm implementing a stock transfer system into the dbase for a new branch interstate. I need to assign new jobnumbers to the items, and in order to avoid duplicates I've decided to use a prefix (In this case ADL for adeliade, and TX for transfer). I've written it all up, and everything...
Back
Top Bottom