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 bkrike 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: *

  • Users: dirklieske
  • Content: Threads
  • Order by date
  1. dirklieske

    Conditional SQL based on user.

    I would like to do the following in SQL: (My goal is to be as efficient as possible in a View not a macro or procedure) IF (Userid = 'BOB') SELECT * FROM table A WHERE Condition = 1 IF (UserID = 'BILL') SELECT * FROM table A WHERE condition = 2 I know I could write the above as...
  2. dirklieske

    Removing Charaters and leaving numbers

    Hi, I am trying to select 1234 from the following field: XXX1234XXX Basically I want to select the numbers and leave the characters behind any sugestions? Also the characters may or may not be there and they may be differing lengths. Thanks in advance.

Part and Inventory Search

Back
Top