Continue to Site

Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

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

Recent content by Necser

  1. Necser

    Please Help with SQL Query.

    Thanks for your responds. How do I check which SQL am I running? We have Borland 6.5 and SQL Explorer 3.0.
  2. Necser

    Please Help with SQL Query.

    select <primary key>,substring(MEMBERNUM from 1 for 1) from CUSTOMERS where substring(MEMBERNUM from 1 for 1) not between '0' and '9' This gives me an SQL error for the first "FROM"..."Token unknown" Any ideas?
  3. Necser

    Please Help with SQL Query.

    Hi, I have a customer table with ~1 million records. I have an external application that performs sertain task to the member number. It requires that the member number is exactly 7 DIGITS long (no letters, simbols, only digits) (table is alphanumeric). There is a record in that table that...
    • Necser
    • Thread
    • Replies: 5
    • Forum: SQL
See more

Part and Inventory Search

Back
Top Bottom