Recent

« previous next »
Pages: [1]

Author Topic: [SOLVED] Shorter statement??  (Read 1469 times)

madref

  • Hero Member
  • *****
  • Posts: 953
  • ..... A day not Laughed is a day wasted !!
    • Nursing With Humour
[SOLVED] Shorter statement??
« on: December 31, 2015, 11:07:13 pm »
Is it possible to make this WHERE-statement shorter?
Code: Pascal  [Select][+][-]
  1.  WHERE ((Wed_Scheids_4<>1) AND (Wed_Scheids_4<>2) AND (Wed_Scheids_4<>3) AND (Wed_Scheids_4<>4))
  2.  
« Last Edit: December 31, 2015, 11:14:17 pm by madref »
Logged
You treat a disease, you win, you lose.
You treat a person and I guarantee you, you win, no matter the outcome.

Lazarus 3.99 (rev main_3_99-649-ge13451a5ab) FPC 3.3.1 x86_64-darwin-cocoa
Mac OS X Monterey

paweld

  • Hero Member
  • *****
  • Posts: 1003
Re: Shorter statement??
« Reply #1 on: December 31, 2015, 11:09:59 pm »
Code: MySQL  [Select][+][-]
  1. WHERE Wed_Scheids_4 not in (1, 2, 3, 4)
Logged
Best regards / Pozdrawiam
paweld

madref

  • Hero Member
  • *****
  • Posts: 953
  • ..... A day not Laughed is a day wasted !!
    • Nursing With Humour
Re: Shorter statement??
« Reply #2 on: December 31, 2015, 11:14:06 pm »
Thanks :D
Logged
You treat a disease, you win, you lose.
You treat a person and I guarantee you, you win, no matter the outcome.

Lazarus 3.99 (rev main_3_99-649-ge13451a5ab) FPC 3.3.1 x86_64-darwin-cocoa
Mac OS X Monterey
Pages: [1]
« previous next »
 

TinyPortal © 2005-2018