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!

Search results for query: *

  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

Part and Inventory Search

Back
Top