fld0             fld1      fld2     fld3
BRKT STRAP        36        3        54
BRKT STRAP        7        4        3
BRKT STRAP        14        27        5
BRKT STRAP        56        29        7
BRKT STRAP        20        31        6
BRKT STRAP        3        2        7
BRKT STRAP        6        3        4

in case upper table,,
criteria :  select [ {count of records in (3 or 4 or 7) in (fld1 or fld2
or fld3)} >= 2 ]

i want the result table below. namely the answer is the below table. i
want not sql server query, but the pure(general) query.

fld0             fld1      fld2     fld3
BRKT STRAP        7        4        3
BRKT STRAP        3        2        7
BRKT STRAP        6        3        4



*** Sent via Developersdex http://www.developersdex.com ***

x taol (tomi3***@yahoo.com) writes:
Show quoteHide quoteSELECT fld0, fld1, fld2, fld3
FROM   tbl
WHERE  CASE WHEN fld1 IN (3, 4, 7) THEN 1 ELSE 0 END +
       CASE WHEN fld2 IN (3, 4, 7) THEN 1 ELSE 0 END +
       CASE WHEN fld3 IN (3, 4, 7) THEN 1 ELSE 0 END >= 2

Views and CTEs performance problem
Adding a space in a field
Can't use Shared Memory protocol to connect
merge two date ranges with overlap from two tables
dynamic sql in UDF