Very Computer

If (Select MATRIXID From SUBSC Where (MATRIXID = '00233' Or MATRIXID =
'00203' Or MATRIXID = '00107' Or MATRIXID = '00010'))
Begin
 Update SUBSC
 Set TIER1 = 'P'
 Where ((Select AGEGRP From SUBSC Where AGEGRP = '1') And
  (Select FAMSIZ From SUBSC Where FAMSIZ = '1'))
End

Server: Msg 156, Level 15, State 1, Line 2
Incorrect syntax near the keyword 'BEGIN'.
Server: Msg 156, Level 15, State 1, Line 5
Incorrect syntax near the keyword 'AND'.
Server: Msg 170, Level 15, State 1, Line 6
Line 6: Incorrect syntax near ')'.

Can anyone tell me what I am doing wrong with this query??

Thanks,

Rey

A select statement doesn't return a true or false like that. Try using the
EXISTS command like:

IF EXISTS (SELECT * FROM ....)

--
Andrew J. Kelly
Targitmail.com

Quote:> I am attempting to perform this query in Query Analyzer and I am receiving
> the following errors:

> If (Select MATRIXID From SUBSC Where (MATRIXID = '00233' Or MATRIXID =
> '00203' Or MATRIXID = '00107' Or MATRIXID = '00010'))
> Begin
>  Update SUBSC
>  Set TIER1 = 'P'
>  Where ((Select AGEGRP From SUBSC Where AGEGRP = '1') And
>   (Select FAMSIZ From SUBSC Where FAMSIZ = '1'))
> End

> Server: Msg 156, Level 15, State 1, Line 2
> Incorrect syntax near the keyword 'BEGIN'.
> Server: Msg 156, Level 15, State 1, Line 5
> Incorrect syntax near the keyword 'AND'.
> Server: Msg 170, Level 15, State 1, Line 6
> Line 6: Incorrect syntax near ')'.

> Can anyone tell me what I am doing wrong with this query??

> Thanks,

> Rey