Post reply

What can I use in stead of the IN operator (to ''AND'' the conditions, not ''OR'')

  • January 26, 2006 at 1:37 am

    #617083

    David

    Instead of SIGN(ISNULL(op.PrefID,0)) could I use ISNUMERIC(op.PrefID)?

    This also gives me a 0 on NULL and a 1 on non-null values.

  • January 26, 2006 at 2:09 am

    #617086

    quoteI do think this is the first time I've seen an inner, left and cross join all in the same query

    Can look complicated but not so bad when you get use to them. I use this a lot to produce data for grids.

    quotecould I use ISNUMERIC...

    Can't see why not

    Probably neater too

    Far away is close at hand in the images of elsewhere.
    Anon.

Viewing 2 posts - 16 through 16 (of 16 total)

You must be logged in to reply to this topic. Login to reply