Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. sunny01

    HOW TO INCREMENT THE NUMERIC PART OF THE STRING

    I HAVE A STRING SUCH AS T123 IT IS A PRIMARY KEY IN ONE OF MY TABLES. ALL I WANT TO DO IS THAT WHENEVER I WANT TO ADD A NEW RECORD I WANT THIS KEY TO INCREMENT BASED ON THE VALUE OF THE PREVIOUS RECORD. I THOUGHT OF USING THE DEMAX FUNCTION AND INSTR FUNCTION BUT IT DIDN'T WORK PLEASE HELP

Part and Inventory Search

Back
Top