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

  1. paultasy

    AND question

    don't worry, I stuck brackets around it: and (lbl_bp_cd || pd_cd || cat_it_cd || pric_cd || convert(varchar,age_restr) || profit_ctr_cd || rptr_grp_cd || series_grp_cd) is NULL
  2. paultasy

    AND question

    Great - that works fine! Neater code!!
  3. paultasy

    AND question

    doesn't work in Sybase - oh well, never mind. The code isn't too cumbersome so I'll stick with the original form! Thanks for looking anyway
  4. paultasy

    AND question

    thanks for that, however, what I am really trying to achieve is to shorten the code if possible?
  5. paultasy

    AND question

    Here's a quick one,,, I have multiple values that I want to check are all NULL to trigger a condition.... Currently it's and A=NULL and B=NULL and C=NULL and D=NULL etc etc.... Is there anyway to write the same as something like: and (A,B,C,D=NULL)? Thanks

Part and Inventory Search

Back
Top