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 Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by cagey7696

  1. cagey7696

    Converting Alphanumeric strings to a unique integer in MS-SQL

    we are really trying to create an interger key equilvalent into a legacy system that for some wierd reason only accepts integers in a field that is deeply entrenched in numerous applications.
  2. cagey7696

    Converting Alphanumeric strings to a unique integer in MS-SQL

    the string can be up to 25 characters long
  3. cagey7696

    Converting Alphanumeric strings to a unique integer in MS-SQL

    it should generate the same integer all the time. I.e. the string would always convert to the same integer. AND a different string would never convert to that integer.
  4. cagey7696

    Converting Alphanumeric strings to a unique integer in MS-SQL

    Yes - I should have been more specific.... Would appreciate any help you can give me with code/function...
  5. cagey7696

    Converting Alphanumeric strings to a unique integer in MS-SQL

    Yes - donutman, no other different string can convert to that same integer... CAn you suggest function ???
  6. cagey7696

    Converting Alphanumeric strings to a unique integer in MS-SQL

    For example I have a string of "4474_SHEET-013-EL_116A", I would like to translate this to a pure integer value.
  7. cagey7696

    Converting Alphanumeric strings to a unique integer in MS-SQL

    It doesn't matter what the integer value is -- it just needs to be unique and the algorithm shoulod always translate the same string to the same integer value..
  8. cagey7696

    Converting Alphanumeric strings to a unique integer in MS-SQL

    Is there a way to convert an alphanumeric string in a vchar field to a unique integer value. The string could contain alpha,numbers,'.','-','_',etc..... ????
See more

Part and Inventory Search

Back
Top