Sql server
thanks ....

>nChar(4) ????'
>

>   select * from numtot where drawdate = @mdate and
> ( <=== YOU WANT THIS ?
>   digit4 = (select price1 from result where drawdate = @mdate) or
>   digit4 = (select price2 from result where drawdate = @mdate) or
>   digit4 = (select price3 from result where drawdate = @mdate) or
>   digit4 = (select spe_1 from result where drawdate = @mdate) or
>   digit4 = (select spe_2 from result where drawdate = @mdate) or
>   digit4 = (select spe_3 from result where drawdate = @mdate) or
>   digit4 = (select spe_4 from result where drawdate = @mdate) or
>   digit4 = (select spe_5 from result where drawdate = @mdate) or
>   digit4 = (select spe_6 from result where drawdate = @mdate) or
>   digit4 = (select spe_7 from result where drawdate = @mdate) or
>   digit4 = (select spe_8 from result where drawdate = @mdate) or
>   digit4 = (select spe_9 from result where drawdate = @mdate) or
>   digit4 = (select spe_10 from result where drawdate = @mdate)or
>   digit4 = (select con_1 from result where drawdate = @mdate) or
>   digit4 = (select con_2 from result where drawdate = @mdate) or
>   digit4 = (select con_3 from result where drawdate = @mdate) or
>   digit4 = (select con_4 from result where drawdate = @mdate) or
>   digit4 = (select con_5 from result where drawdate = @mdate) or
>   digit4 = (select con_6 from result where drawdate = @mdate) or
>   digit4 = (select con_7 from result where drawdate = @mdate) or
>   digit4 = (select con_8 from result where drawdate = @mdate) or
>   digit4 = (select con_9 from result where drawdate = @mdate) or
>   digit4 = (select con_10 from result where drawdate = @mdate)
>)
>

>
>I THINK YES.
>CHR(0) Can to be into digit4. I think No.
>

>   select * from numtot ;
>   JOIN result ON  result.drawdate=numtot.drawdate;
>   WHERE numtot.drawdate = M.mdate ;
>  AND AT(numtot.digit4+CHR(0),result.price1+CHR(0)+result.price2+CHR(0)+...+CHR(0)+result.con_10+CHR(0))>0
>